Access combine or exclude two fields.

[accessmatt]

Hello,

Can anyone confirm or have other suggestions for how to run these two different queries, one combines on 2 fields and another excludes on 2 fields?

Combine on 2 fields:



SELECT [Combines on 2 fields - step 1].[Unique ID Field A], [Combines on 2 fields - step 1].[Unique ID Field B]FROM [Combines on 2 fields - step 1] LEFT JOIN [Table 2] ON [Combines on 2 fields - step 1].[Unique ID Field B] = [Table 2].[Unique ID Field B];


Exclude on 2 fields:

SELECT [Table 1].ID, [Table 1].[Unique ID Field A], [Table 1].[Unique ID Field B]FROM [Table 1] LEFT JOIN [Table 2] ON ([Table 1].[Unique ID Field B] = [Table 2].[Unique ID Field B]) AND ([Table 1].[Unique ID Field A] = [Table 2].[Unique ID Field A])
WHERE ((([Table 1].[Unique ID Field B]) Is Null) AND (([Table 2].[Unique ID Field A]) Is Null));

[orange]

How about an example of what these mean? And/or a clear description in simple English?

combines on 2 fields

Exclude on 2 fields

[accessmatt]

@orange,

sorry for the confusion. Basically the "combine on 2 fields" mean that the query checks to see if either of 2 id fields match and if so than joins on those matches. "exclude on 2 fields" does the reverse - checks to see if 2 fields don't match and if not doesn't make those joins. Does that make sense?