>Hi. VFP7 user. How (in Fox sql) do I select ALL of the records in the parent table, whether (or not) they have a record in the child table?
>
>IOW: I want to report all of my customers and list their invoices (if they have any)
>
>Thanks, Randy
You would use LEFT OUTER JOIN
SELECT * FROM parenttable pt ;
LEFT JOIN childtable ct ON ct.keyfield = pt.keyfield
--sb--