Unmatched query

  • Thread starter Thread starter MARK GARNER
  • Start date Start date
M

MARK GARNER

I am trying to make a unmatched query over two tables with criteria in both
tables (this is where the problem lies).

Table A


PartNum (Tied to Sku, B)
Title
Fcwave = "98" (this is the criteria and it doesn't match the other table)

Table B

Sku Wave = "1048"

It work's until I try and add any criteria to it.

I was able to create two queries with each one based on the criteria, then
build a third query over the two tables. How do you build Sql within Sql?
 
I was able to create two queries with each one based on the criteria, then
build a third query over the two tables. How do you build Sql within Sql?
Click to expand...

With a Subquery; or, you can create a new Query by joining two Queries
if you wish.

I can't figure out from your post what the joining fields should be,
but you could post the SQL of your two queries if you wish.

John W. Vinson[MVP]
 
Back
Top