Hi,
i am using query to have common rows like here with inner join:
what ill be the opposite syntax of it to get not common values? outer join in access doesnt exist?
How can i change the query ?
Best,
Jacek
i am using query to have common rows like here with inner join:
Code:
SELECT DISTINCTROW temp.DisplayName, temp.Topology, temp.Tier, temp.Platform, temp.OSDistro, temp.OSVersion, temp.Origin, temp.PlatformRepository, temp.ImageID, temp.Publisher, temp.Offer, temp.SKU, temp.Version, temp.Urn, temp.OS, temp.SystemNameFull, temp.Customer
FROM Temp_Images AS temp inner join tblImages AS t1 ON (temp.Customer = t1.Customer or (temp.Customer is Null AND t1.Customer is Null))
AND (temp.SystemNameFull = t1.SystemNameFull or (temp.SystemNameFull is Null AND t1.SystemNameFull is Null))
AND (temp.OS = t1.OS or (temp.OS is Null AND t1.OS is Null))
AND (temp.Urn = t1.Urn or (temp.Urn is Null AND t1.Urn is Null))
AND (temp.Version = t1.Version or (temp.Version is Null AND t1.Version is Null))
AND (temp.SKU = t1.SKU or (temp.SKU is Null AND t1.SKU is Null))
AND (temp.Offer = t1.Offer or (temp.Offer is Null AND t1.Offer is Null))
AND (temp.Publisher = t1.Publisher or (temp.Publisher is Null AND t1.Publisher is Null))
AND (temp.ImageID = t1.ImageID or (temp.ImageID is Null AND t1.ImageID is Null))
AND (temp.PlatformRepository = t1.PlatformRepository or (temp.PlatformRepository is Null AND t1.PlatformRepository is Null))
AND (temp.Origin = t1.Origin or (temp.Origin is Null AND t1.Origin is Null))
AND (temp.OSVersion = t1.OSVersion or (temp.OSVersion is Null AND t1.OSVersion is Null))
AND (temp.OSDistro = t1.OSDistro or (temp.OSDistro is Null AND t1.OSDistro is Null))
AND (temp.Platform = t1.Platform or (temp.Platform is Null AND t1.Platform is Null))
AND (temp.Tier = t1.Tier or (temp.Tier is Null AND t1.Tier is Null))
AND (temp.Topology = t1.Topology or (temp.Topology is Null AND t1.Topology is Null))
AND (temp.DisplayName = t1.DisplayName or (temp.DisplayName is Null AND t1.DisplayName is Null))
AND (temp.Topology = t1.Topology or (temp.Topology is Null AND t1.Topology is Null));
what ill be the opposite syntax of it to get not common values? outer join in access doesnt exist?
How can i change the query ?
Best,
Jacek