hi
I am having problem regarding sql query.
My query consists of three tables in MS Access that I want to join the together.
My query is:
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'
Now this query gives me various identical records which actually does not exist.
I want to view the three relevent records (where Proceed_Retrofit = 'yes') from Customer_details and the associated data from the other tables.
please help me regarding his sql query.
your views will be appreciated
Bookmarks