>>Ok I lost the file that showed how to do an outer join in fp2.6.
>>
>>can anyone help me out?
>>
>>srussell@bdbc.com wk
>>srussell@wnm.net hm
>>
>>TIA
>>
>>__Stephen Rusell
>>Memphis FPUG
>Stephen,
>
> SELECT ;
> FROM TableA, TableB ;
> WHERE TableA.PrimaryKey = TableB.ForeignKey ;
> UNION ;
> SELECT ;
> FROM TableA ;
> WHERE TableA NOT IN(SELECT ForeignKey FROM TableB)

I believe Jim left ".PrimaryKey" off the "TableA" in the last WHERE clause.

Mark McCasland
Midlothian, TX USA