I think you have the syntax wrong.

Try this:

SELECT idnum FROM active T1 FULL OUTER JOIN inactive T2 ON T1.idnum = T2.Idnum

Dennis McGrath


Reply via email to