try:
select t1.* from table1 t1 right outer join table2 t2 on t1.ref = t2.ref
where t2.ref is null
or swap your tables and left/ right
Andrew Davies MBCS CITP
- AndyD 8-)#
**********************************************************************
This email and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed. If you have received this email in error please notify the system manager.
This footnote also confirms that this email message has been swept by MIMEsweeper for the presence of computer viruses.
Please contact internet.administrators At manchester D.OT gov.uk with any queries.
**********************************************************************
©2006 Andy Davies |
