Creating Query between 2 tables

  • Thread starter Thread starter Carla
  • Start date Start date
C

Carla

What steps do i take to create a query to pull data from
2 different tables? For example: TableA: has $$ data
and TableB: has grading scale (need to find if student
has A or B grade). How can i pull both pieces of data
from 2 separate tables to answer my query?

Any help would be appreciated,
thank U
 
Carla,

You need to include both tables in your query, and create a
relationship between those tables on a common field (it sounds like
both the tables you need should have a 'GRADE' field or similar).

HTH


=================================================================
 
Back
Top