Exclusion Table with two matching Criteria

[pocquet]

Hi Guys,

I need to exclude a number of vendors from a list.

The easiest way for me to do this would be to use a table to exclude records.

Tbl_Vendor_List
Fields: Vendor number, Vendor name, Vendor Cat, Spend

Tbl_exclude
Fields: Vendor Number, vendor Cat, exclusion Reason

I have done this in the past by linking vendor numbers and using a join to exclude them. However I need to evaluate both vendor number and vendor cat (if either dont match then I dont want to exclude them).

Is this possible and how?

Thanks

Jon

 

[xenou]

Hi, you can use OR in your join clauses.
ξ

 

[james_lankford]

Hi, you can use OR in your join clauses.
ξ

wait, what ? !

whoa ! I learned something new

I got google that

 

[xenou]

Looks like not supported in MSAccess Design View but definitely possible with raw SQL:

SELECT * 
FROM
	Table9 a
	INNER JOIN
	Table10 b
	ON
		a.VendorNum = b.VendorNum
		OR a.VendorCat = b.VendorNum;

Using old SQL-89 syntax can also be written this way (and is supported in Design View):

SELECT *
FROM 
    Table9 a, Table10 b
WHERE 
	a.VendorNum = b.VendorNum
	OR a.VendorCat = b.VendorNum;