Are both idnums indexed?
-----Original Message-----
From: [email protected] [mailto:[EMAIL PROTECTED] On Behalf Of Jason Kramer
Sent: Wednesday, September 24, 2008 8:43 AM
To: RBASE-L Mailing List
Subject: [RBASE-L] - RE: FULL OUTER JOIN question
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
>
>
>
