Hi Larry,

That's great. Just one more small clarification. Will there be any performance degradation using this way? Thanks

>I believe the following will work in both:
>SELECT field1, field2, mytable2.field3 FROM mytable1,mytable2 ;
> where mytable1.field1 = mytable2.field1
>UNION
>SELECT field1, field2, ' ' as field3 FROM mytable1 ;
> where mytable1.field1 not in (select mytable2.field1 from mytable2)

>You have to go back to the days before we had outer joins in VFP.