Combining tables in one sql instead of 2 in query

[jaryszek]

Hi,

i am trying to do in one query left join like here:

as you can see it will work. Problem is that i have to match not only CustomerTopologyID but also ServerID with ServerIDFK in tblCustomerTopologyServers table.

But when i am doing:

i am getting error.

Please help,
Jacek

 

[MajP]

I think instead of a join you can do the last one as a where

where qry...Done.serverID = tbl...ServerIDFK

 

[CJ_London]

To add to MajPs suggestion, to maintain the left join the criteria needs to be

where qry...Done.serverID = tbl...ServerIDFK OR tbl...ServerIDFK is null

Another way is to combine the two smaller tables -

SELECT *
FROM tbl1 LEFT JOIN (SELECT * FROM tbl2 LEFT JOIN tbl3 ON .....) C ON .....

 

[jaryszek]

thank you Guys very much,

Best,
Jacek