Question: Hello all, I have three tables in MS Access that I want to join called...
Customer_Details, EMAS and work_orders
My current query
SELECT * from (Customer_Details
left join EMAS on Customer_Details.street_name = EMAS.street_name )
left join work_orders on Customer_Details.ID = work_orders.customer_ID
where Proceed_Retrofit = 'yes'
gives me dozens of nearly identical records in response which don't exist.
What I want to see is the three relevent records (where Proceed_Retrofit = 'yes') from Customer_details and the associated data from the other tables.