Need little help on querying two tables

P

paulzone2k

Just joined this forum and posting my very first thread.. ^^

I need to create query to pull data from two different tables. Thi
should be really easy query for most of you. Once someone help me se
it up, I can do the modifying.

If you look at the image, there are two tables. For each of pf_i
(which is unique ID), I need to know the dept_name which is on othe
table. I know two tables can be linked with dept_id but I don't kno
how to create query. If you can help me , I would greatly appreciat
it~


Result should be like below.

pf_id, dept_id, dept_name
___________________________
wh08051bh-Navy, 01-001, washed hat
wh60516bh-white, 01-001, washed hat
 
D

Duane Hookom

Begin creating a new select query and select both tables. You can drag the
Dept_ID field from the lookup table and drop it on the Dept_ID from the
other table. Add whatever fields you want to the grid. If there are records
with a Dept_ID, you may need to change the properties of the join to include
all the records from the main table.
 
Top