[RBASE-L] - RE: FULL OUTER JOIN question

[Jason Kramer]

Dear Dennis,
   Thanks.  I just tried that I keep getting only the idnums in the 
first table.
                                             Jason
Jason Kramer
University Archives and Records Management
002 Pearson Hall
(302) 831 - 3127 (voice)
(302) 831 - 6903 (fax)



Dennis McGrath wrote:
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