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

Janis

www.JamesBooth.com