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