Re: Returning Unique Records

[Vernon]

Sorry I had to drop this until I figured my other problem out but have to now return to this. I have modified the SQL and have returned the correct amount of records, however the cust_check_num is always NULL when in fact it should only return have of them as NULL as half have actually been paid. (Peter if you're reading this it is the same database as before.)

SELECT
customer_ads.id,
customer_ads.client_id,
customers.company,
customer_ads.start_date,
receivables.cust_check_num
FROM
customer_ads
LEFT OUTER JOIN customers ON (customer_ads.client_id = customers.customers_id)
LEFT OUTER JOIN receivables ON (customer_ads.id = receivables.recordID)
WHERE
(customer_ads.client_id = '41') AND
(customer_ads.start_date >= '2006-01-01') AND
(customer_ads.start_date <= '2006-01-31')