this is the top part and bottom part into SQL
but the connecting part to both .. that seems to be missing ... common table
on dbo_Action.Client_Id = dbo_Products.Client_Id
and dbo_Action.Product_No = dbo_Products.Product_No
and dbo_Action.Client_Id = dbo_Products.Client_Id
on dbo_Action.Client_Id = dbo_Customer.Client_Id
and dbo_Action.Client_Id = dbo_Customer.Client_Id
on dbo_Uplift.Payment_Ref = dbo_Purchase.Payment_Ref
and dbo_Uplift.Payment_Ref = dbo_Purchase.Payment_Ref
on dbo_Uplift.Purchase_Type = dbo_PurchaseCode.TypeCode
and dbo_Uplift.Purchase_Type = dbo_PurchaseCode.TypeCode
Thanks for looking into this for me. I don't know how to join the top and bottom parts of the query. The query does work in MS Access.
Can you write the full query in SQL for me ?
Is this query possible in SQL?