Query Help 1

[hubcap1324]

Ok I am fairly new to SQL language and need some help with what looks like a simple query. All of the records are in one table so it should be straightforward but I am hung up on how to get one of the needed columns.

Table name is persnl
Columns are persnl_id, mgr_id, job_type, per_dob, first_name, last_name

I need to pull two job_types: accttmps and prodtmps listing their names, dob and the employee's mgr name. Their is not a separate mgr name field as the manager names are in with the rest of the employees.

SELECT first_name, last_name, per_dob
FROM persnl
WHERE persnl_id LIKE 'accttmps'
OR persnl_id LIKE 'prodttmps'

My issue is how I get the manager name from this? The mgr_id field lists the manager id for that particular employee so I somehow need to take that mgr_id and reference it back to the managers persnl_id to get their name. I just cannot figure that part out....

I appreciate any help on this....

 

[r937]

change this --

WHERE persnl_id LIKE 'accttmps'
   OR persnl_id LIKE 'prodttmps'

to this --

WHERE persnl_id IN ('accttmps','prodttmps')

then look at this tutorial:

http://support.microsoft.com/kb/114592

ignore that it is written for access and vb, and look at just the SQL


r937.com | rudy.ca

 

[hubcap1324]

Extremely helpful. Many thanks as I got it to work beautifully!