A quick quesiton on LEFT Joins

• NadJ

  Ten Centuries

  Points: 1031

  More actions

  December 18, 2004 at 9:14 am

  #60035

  I already have a select query which performs a LEFT join with another table. How do I arrange the syntax to perform LEFT joins on further tables within the same query?

  Does this make sense, or shall I further clarify what I mean?

  Thanks to all those who have helped me thus far. I started of with minimal T-SQL skills, and now with my project 90% complete feel have learnt shed-loads

• Bob Monahon

  Ten Centuries

  Points: 1282

  More actions

  December 18, 2004 at 11:28 pm

  #534405

  Here's a sample, using the following 3 tables:

   ChangeRequests

   Titles

   MagGroups

   

  SELECT cr.bill_to, cr.title_id, tt.title, tt.mag_group, mg.mag_group_id

  FROM

  (dbo.ChangeRequests AS cr

    LEFT JOIN dbo.Titles AS tt

    ON cr.title_id = tt.title_id)

  LEFT JOIN dbo.MagGroups AS mg

  ON tt.mag_group = mg.mag_group;

  ---

  Regards,

  Bob Monahon