So far I have the statement:
Code: Select all
SELECT A.*, B.*, c.FirstName, c.Surname, c.CompanyName, D.name, D.compName
FROM A as A, B as B, C as C, D as D
WHERE A.uid = B.id
AND A.accmngr = 'name'
AND (A.sageCode = C.cs3
OR A.sageCode = D.cs3)
Am I structuring my statement wrong or is this not possible in 1 single query?