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

I know FoxPro 2.x didn't have an outer join, but I thought they introduced it back in VFP 3. I don't have VFP 3 installed anywhere to check, but if that doesn't work, then you'd have to use a UNION:

SELECT Table1.*, Table2.SomeField ;
   FROM Table1, Table2 ;
   WHERE Table1.cID = Table2.cID ;
   UNION ALL ;
       SELECT Table1.*, space(somenumber) as SomeField ;
          WHERE Table1.cID NOT IN (Select cId From Table2) ;
   INTO...