Show name instead of ID 1

[l3reacher]

Hello I have a table called 'staff' and another name 'course'

Under 'staff' table is:

StaffID
FirstName
Lastname


Under 'Course' is:

CourseID
StaffID
CourseName

My questions is when I do a query under SQL, how do I show the staff's FirstName and Lastname instead of showing the StaffID.

I Hate Spammers and Flammers!!!

 

[PHV]

Simply join the tables:
SELECT C.CourseID, C.CourseName, C.StaffID, S.FirstName, S.LastName
FROM tblCourse C INNER JOIN tblStaff S ON C.StaffID = S.StaffID

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

 

[l3reacher]

Thanks, it works.

I Hate Spammers and Flammers!!!