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
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