select ld from t1 <operator> select ld from t2; Operator�������� Returns� UNION�� ������� All rows selected by either query.� UNION ALL��� All rows selected by either query, including all duplicates.� INTERSECT � All distinct rows selected by both queries.� MINUS��� ����All distinct rows selected by the first query but not the second.
JP On Thu 25. October 2001 10:35, you wrote: > Hallo you DBA' > > Can anyone give me a good example on a sql select statement checking which > ids exists in table one but not in table two? Table two also contains the > corresponding id field but with other field names besides. Like this > > Table 1: Id Name Year > Table 2: :Id City Country > > Thanks in advance > > Roland Sk�ldblom -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jan Pruner INET: [EMAIL PROTECTED] Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists -------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
