selecting from three or more relational tables

I have Three tables in SQL 2012.  They are related in the following scheme below.

tblGoals
GoalID - Primary Key

tblObjectives
GoalID- Foreign Key
ObjectiveID- Primary Key

tblPI
ObjectiveID- Foreign Key
PIID-Primary Key

 If I would like to call all the records between all the tables (ie, Goals, related Objectives, related PI, how would I select them all?

Would it look like this?


Select *
From tblGoals G
Inner Join tblObjective O on G.GoalID = O.GoalID Inner Join ????

You see where I am struggling....
al4629740Asked:
Who is Participating?
 
Steve WalesConnect With a Mentor Senior Database AdministratorCommented:
You just about had it.

Select *
From tblGoals G
Inner Join tblObjective O on G.GoalID = O.GoalID
Inner Join tblPI P on O.ObjectiveID = P.ObjectiveID

That should cover it, I believe.

If you want to get more selective you can list the various columns:

select g.GoalID, O.ObjectiveID, P.PIID, etc etc etc
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.