Count Null records AND...... (1 Viewer)

[Matizo]

Hi guys,

I know how to count records so that null records would be counted but I do not know how to do this:

I have customers and works. I want to create a query that will show ALL customers and number of works done for that customer (sometimes there is no work done for customer).

How can I do it?

Thanks,
Matt

 

[Moniker]

Assuming you have a normalized structure, that's a left join between the customer table and the works table.

Customer Table
CustomerID (PK)
CustomerName
OtherCustomerInfo

Works Table
CustomerID --/ (Both are PK)
WorksID ----/
WorksName
OtherWorksInfo

LEFT JOIN Customer Table to Works Table on the CustomerID field to get the results you want.

 

[Matizo]

Thanks! It works

regards,
Matt