Help needed writing a query 1

[fergmj]

Hi I need some help writing a query

I have two tables in my database
SCHEDULE and STAFF
I have a query that extracts data from SCHEDULE:
SELECT Schedule_No, Rate, StartDate, EndDate, Staff_No FROM dbo.SCHEDULE where Client_No=@Client_No

Staff_No and Staff_Name are the only two columns in the STAFF table.

I want to get the Staff_Name where the Staff.Staff_No = SCHEDULE.Staff_No but as part of the original query above.

 

[r937]

SELECT sc.Schedule_No
     , sc.Rate
     , sc.StartDate
     , sc.EndDate
     , st.Staff_Name 
  FROM dbo.SCHEDULE AS sc
INNER
  JOIN dbo.STAFF AS st
    ON st.Staff_No = sc.Staff_No 
 WHERE sc.Client_No = @Client_No

r937.com | rudy.ca