When I run the following query I get the expected results:
SELECT Sponsor_Request_Table.SponsorRequestID_PK,Sponsor_ Request_Table.OldRFID, Sponsor_Request_Table.AirTimeSponsor,Employee_List _Table.EmployeeInitials, Sponsor_Request_Table.Status,Sponsor_Request_Table .RequestedDate, Sponsor_Request_Table.RequiredDate,Sponsor_Request _Table.Notes, Order_Details_Table.Qty,Order_Details_Table.Refurb , Order_Details_Table.DefaultProgramming,Order_Detai ls_Table.OrderDetailNotes, Order_Details_Table.KitID_FK,Order_Details_Table.I temID_FK, Order_Details_Table.TechID_FK
FROM (Employee_List_Table INNER JOIN Sponsor_Request_TableON Employee_List_Table.EmployeeID_PK = Sponsor_Request_Table.EmployeeID_FK)INNER JOIN Order_Details_Table ON Sponsor_Request_Table.SponsorRequestID_PK =Order_Details_Table.SponsorRequestID_FK
WHERE (((Sponsor_Request_Table.Status)="OPEN" Or(Sponsor_Request_Table.Status)="PARTIAL"));
I Then want to add additional details from another table Kit_Table, it yields NO Results...frustrating:
SELECT Sponsor_Request_Table.SponsorRequestID_PK,Sponsor_ Request_Table.OldRFID, Sponsor_Request_Table.AirTimeSponsor,Employee_List _Table.EmployeeInitials, Sponsor_Request_Table.Status,Sponsor_Request_Table .RequestedDate, Sponsor_Request_Table.RequiredDate,Sponsor_Request _Table.Notes, Order_Details_Table.Qty,Order_Details_Table.Refurb , Order_Details_Table.DefaultProgramming,Order_Detai ls_Table.OrderDetailNotes, Order_Details_Table.KitID_FK,Order_Details_Table.I temID_FK, Order_Details_Table.TechID_FK
FROM Kit_TableINNER JOIN ((Employee_List_Table INNER JOIN Sponsor_Request_Table ONEmployee_List_Table.EmployeeID_PK = Sponsor_Request_Table.EmployeeID_FK) INNERJOIN Order_Details_Table ON Sponsor_Request_Table.SponsorRequestID_PK =Order_Details_Table.SponsorRequestID_FK) ON Kit_Table.KitID_PK = Order_Details_Table.KitID_FK
WHERE (((Sponsor_Request_Table.Status)="OPEN" Or(Sponsor_Request_Table.Status)="PARTIAL"));