selecting from three or more relational tables
Posted on 2013-12-27
I have Three tables in SQL 2012. They are related in the following scheme below.
GoalID - Primary Key
GoalID- Foreign Key
ObjectiveID- Primary Key
ObjectiveID- Foreign 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?
From tblGoals G
Inner Join tblObjective O on G.GoalID = O.GoalID Inner Join ????
You see where I am struggling....