Need little help on querying two tables

[paulzone2k]

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

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

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


Result should be like below.

pf_id, dept_id, dept_name
___________________________
wh08051bh-Navy, 01-001, washed hat
wh60516bh-white, 01-001, washed hat
.
.
.
ru11072bh-white_with_navy, 01-002, roll up bucket hat
.
.
dh03871bh-Dk._Blue, 01-003, denim hats
.
.

<img src="

http://www.highdots.com/forums/attachment.php?attachmentid=183">

 

[PHV]

SELECT P.pf_id, P.dept_id, D.dept_name
FROM e4hats_dept_prod AS P INNER JOIN e4hats_dept AS D ON P.dept_id = D.dept_id

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886