Display names from tbl 2 based on ID's in tbl1

[MikeyJ]

Hi all,

Silly question I'm sure but it's escaping me at the moment.

Here's the important parts of 2 tables I have:

tblCallbacks
-----------------
CBID
CSR1

tblEmployees
-----------------
EmpID
EmpFirstName

On my data entry page I have a dropdown box that is populated from
tblEmployees. It's values are the EmpID's. These values are written into the
CSR1 field in tblCallbacks.

Question is...when I want to pull up a list of callbacks from tblCallbacks,
how do I show the name from tblEmployees instead of the ID in tblCallbacks.CSR1?

I just can't get the query for some reason....

Thx!
Mike

[Kronin555]

select tblcallbacks.cbid, tblemployees.empfirstname
from
tblcallbacks JOIN tblemployees ON (tblcallbacks.csr1 = tblemployees.empid)

[MikeyJ]

Wow! Thx for the fast reply! Your solution works like a charm.

Now, to throw a curveball atcha. ;-)

I also have a field in tblCallbacks named CSR2. It works the same as CSR1 in
that it also holds an EmpID. How do I do the same for CSR2? I need to display
the corresponding names for both CSR1 and CSR2 in the same record.

Hope I explained well enough.

Thx again!
Mike

[mxstu]

You may need to add parenthesis to the JOIN statements depending on your
database....


SELECT cb.cbid, e1.empfirstname, e2.empfirstname
FROM tblcallbacks cb JOIN tblemployees e1 ON cb.csr1 = e1.empid
JOIN tblemployees e2 ON cb.csr2 = e2.empid

[MikeyJ]

Thanks! This worked perfectly.

In actuality, both yours and Kronin555's answers were correct and helped me move forward!

Mike