SELECT StationQuery.Tooling_Station, manu.Man, autom.Auto, manu1.Man1, autom1.Auto1
FROM (((StationQuery LEFT JOIN manu ON StationQuery.Tooling_Station = manu.Tooling_Station) LEFT JOIN autom ON StationQuery.Tooling_Station = autom.Tooling_Station) LEFT JOIN manu1 ON StationQuery.Tooling_Station = manu1.Tooling_Station1) LEFT JOIN autom1 ON StationQuery.Tooling_Station = autom1.Tooling_Station1;
this was my query to get a result for Man,Auto,Man1,Auto1 ,Now I want to add man and man1 but the result what am getting is partial i.e. if I have values in both man and man1 its showing result but remaining fields are blank if either man or man1 is blank ????