Query Criteria for a Newbie

  • Thread starter Thread starter Nurse Nancy
  • Start date Start date
N

Nurse Nancy

I have a Query with many tables. So far I have gotten the results I need just
by using the Outer Joins.

Now the last step is to compare 2 tables with similar fields.

Product Table and Station Table

I only want to return records from the Station Table if the Station Rank is
less than or equal to the Product Rank

So What do I put in the Criteria field for each of these fields?

Hope you can help me
Nancy
 
Back
Top