I am have difficulty with duplicates with a two table query. One table is Customers and the othe table is Guests as it relates to customers having guests in their room.
Customers can have a room without guests (single occupancy) but I need to query both tables for a total count (Customers + Guests).
SELECT tblCustomers.IngCustomerID, tblCustomers.txtCustomerFirstName, tblCustomers.txtCustomerLastName, tblGuests.IngCustomerID, tblGuests.IngGuestID, tblGuests.txtGuestFirstName, tblGuests.txtGuestLastName
FROM tblCustomers, tblGuests
WHERE (((tblCustomers.IngCustomerID)=[tblGuests].[IngCustomerID] Or (tblCustomers.IngCustomerID)<>[tblGuests].[IngCustomerID]));
I have attached a *pdf with the joins and query output.
Thanks