Hi Randy

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

You need an OUTER JOIN for this.

SELECT * ;
  FROM customer LEFT OUTER JOIN invoices ;
    ON customer.customer_id = invoice.customer_id
 WHERE [add condition if needed]

This will give all rows from the LEFT table (customer) plus any matches from the RIGHT table (invoices). Note that non-matching records return NULL in the fields from the right table...!