>Hello Ed,
>
>I checked my MSDN and LEFT OUTER JOIN only appeared on VFP 5.0
>
>That view is contained in a grid.
>
>Is there something that I can do to make it OK for a grid?
You can use cursor:
Select table1.field1, table2.field2 ;
From Table1,Table2 ;
Into Cursor mycursor ;
Where Table1.id=Table2.id ;
Union Select table1.field1, "" as field2 ;
From table1 Where id NOT IN (Select id From Table2)
Edward Pikman
Independent Consultant