LearnItFirst User Forum

Welcome Guest

Search | New Posts | Members | Log In | Register

SQL Server Forum - LearnItFirst.com » Transact-SQL Programming » DML (SELECT, INSERT, UPDATE, DELETE) Questions » LEFT JOIN , Please help

LEFT JOIN , Please help

Options

Previous Topic · Next Topic

rgm3159

Posted: Tuesday, June 08, 2010 5:25:23 PM

Rank: Newbie

Joined: 6/8/2010
Posts: 4
Points: 12
Where do you live?: NJ

Hi Everyone,

I have a question in writing a query of 3+ LEFT JOIN tables. How do I know which
table to put first, second ..and so on in my query? Can you please
enligthened me about this.

ex. Immunization report

Students table (StudID, Fname, LName)

Immunization table ( ImmunizationCode, ReceivedDate, StudId)

ImmunizationLookup table ( ImmunizationCode, ImmunizationDesc)

Thank you,

rgm3159

Scott Whigham

Posted: Wednesday, June 09, 2010 1:24:33 PM

Rank: Super Mod

Joined: 3/20/2006
Posts: 476
Points: 1,053
Where do you live?: Dallas, TX

Well, first you need to understand INNER JOINs completely. Only once you understand those can you begin to understand the OUTER JOINs.

Have you watched chapter 4 ("Writing JOINs and UNIONs" Wink

of Course 160, my query writing course? I cover that overly much probably Smile

Users browsing this topic

Guest

Forum Jump

You cannot post new topics in this forum.
You cannot reply to topics in this forum.
You cannot delete your posts in this forum.
You cannot edit your posts in this forum.
You cannot create polls in this forum.
You cannot vote in polls in this forum.