You can use the intersect, union, and minus SQL operators in SQR queries by adding them to the SQL statement that follows the FROM and WHERE clauses.

The SELECT list for the secondary SQL statement in the union, intersect, or minus query must match the data type, number of columns, and length of columns selected in the first query. If you select string expressions or literals, make sure that the lengths of the fields in both SELECT lists are the same.

Enter the part of the SQL statement that follows the union, minus, or intersect clauses normally; that is, with commas between column names and without alias names, as shown below:

begin-select
cust_num (1,1) edit 099999
co_name (,9,30)
name (,+2,25)
city (,+2,18)
state (,+2,2)
zip (,+1) edit xxxxx-xxxx
from customers where state in ('OH', 'IN', 'MI')
union select cust_num, co_name, name, city, state, zip
from prospects where state in ('OH', 'IN', 'MI')
and first_contact >= '01-JAN-88'
order by 2
end-select