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....