| Recommend this page to a friend! |
| Classes of Tom Schaefer | > | SQL Parse and Compile | > | samples/union.sql | > | 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';
|