Problem writing Subquery

I am trying to see if a product's model number or UPC code are listed inside a "do not show" table. I have written a query that looks to see if BOTH are found, but I need a query to looks for either one to be true.

ModelNumber in Table A = ModelNumber in Table B
or
UPC in Table A = UPC in Table B

Here is the query that isn't working. It looks for both to be true. How do I write this so that either are true.

Select distinct A.ModelNumber, A.upc
FROM A
WHERE (A.ModelNumber, A.UPC) NOT IN (select B.UPC, B.ModelNumber from B)
and A.ModelNumber= '#form.xyz#'

Thank you in advance!

Scott

When a modelnumber is passed to this query I realize I could write this differently, but this query also needs to find ALL NON-Matching products when a modelnumber is not passed to this query.

Thank you for posting this query. The query works great when the model number is passed (#form.xyz#), but it hangs when trying to find ALL products from TABLE A that are not in TABLE B using the same two fields (ModelNumber and UPC).

For example, if I try to query all products from TABLE A that are not in TABLE B the query hangs. Even if I limit the query to the first 100 products (limit 0,100) it takes almost 5 seconds, making it unusable for a table with over 5,000 SKU's.

Any suggestions on a query to use when trying to find more than just a few matches?

Thanks again for your help.

Scott

try this --