>SELECT Table1.*, Table2.SomeField ;
> FROM Table1
> LEFT OUTER JOIN Table2 on Table1.cId = Table2.cID ;
> INTO...
>You may want to use the NVL function around the field from Table2 so that >null values don't show up as NULL.
Thanks for the response. I'm afraid this is not going to work because left outer join is not supported in visual foxpro 3.0. I could be wrong, I don't have a version 3.0 on my home computer.I have to wait till monday to test it on the computer at the office.
Zakaria al Azhar