RE: Join file 1 and 2, but only if not in 3

[Peter_Vidal@xxxxxxxx]

Thanks Elvis!

SELECT  T02.ITNBR, T02.STID, T02.ITRV, T02.ITDSC, T02.UNMSR, T02.QCTYP, 
T02.QCDAY, T02.INTYP, T02.BLCF, T02.ALLOC 
FROM WHDTA/SHRITMS T01 
EXCEPTION JOIN IMHIST T03 ON T02.ITNBR = T03.ITNBR 
INNER JOIN AMFLIB1/ITMRVA T02 ON T01.ITNBR = T02.ITNBR AND STID = 'H1P'    
 
ORDER BY  T02.ITNBR ASC, T02.ITRV ASC 

SQL is giving an error "Column qualifier or table T02 undefined" on the 
relation T02.ITNBR = T03.ITNBR

PETER VIDAL 
MAPICS IT TECHNICAL SUPPORT TEAM / SR SYSTEM ANALYST 
10540 Ridge Rd., Suite 203, New Port Richey, FL 34654-5111
Tel:727-849-9999, x2414 /// Fax:727-815-3120
WWW.PALL.COM 

"People will not look forward to posterity who never look backward to 
their ancestors."
Edmund Burke

--------------------------------------------------------------------------------

Attention:

This communication may contain information that is confidential,
privileged and/or exempt from disclosure under applicable law.  
If you are not the intended recipient, please notify the sender 
immediately and delete the original, all attachments, and all 
copies of this communication.


--------------------------------------------------------------------------------