Recommend this page to a friend! | Stumble It! | Bookmark in del.icio.us |
Classes of Tom Schaefer | > | SQL Parse and Compile | > | samples/union.sql | > | Download | ||
|
Download |
SELECT field1_index, field2_index FROM test_table WHERE field1_index = '1' UNION SELECT field1_index, field2_index FROM test_table WHERE field2_index = '1'; |