Create a Join in a Query

Prev Show Me Next

Get Ready
Display the query in Design view. Click here: GO if you don't know how to do this. Use the Back button on your Browser to return here when you're through.
Identify the related field in each table:
Example: Product ID

Begin
Drag the related field from one table to the other.