CODEWITHSUNDEEP
sqlsql-servert-sql
Mayur Dhingra
Mayur Dhingra

Reputation: 1577

Inner Join on three tables linked by foreignkeys

I am new to SQL programming and have the following scenario. I have three tables which are linked to each other as -

ForceInstance

ForceInstanceID (PK)
ForceID (FK to Force)
Description
CreatedBy
CreatedOn

Force

ForceID (PK)
ForceTypeID (FK to ForceType)
Description
CreatedBy
CreatedOn`

ForceType

ForceTypeID (PK)
Description

I want to make a join of the three tables, I tried this query -

Select * from ForceInstance FI inner join 
              Force F inner join
              ForceType FT
          on  FI.ForceID = F.ForceID
          and F.ForceTypeID = FT.ForceTypeID

but was unable to achieve anything. I am new to SQL and wanted to know how to achieve this.

Upvotes: 0

Views: 51

Answers (3)

Navneet
Navneet

Reputation: 447

 Select * from ForceInstance FI  join 
              Force F 
              on  FI.ForceID = F.ForceID
             JOIN ForceType FT           
               on F.ForceTypeID = FT.ForceTypeID

Upvotes: 0

Giannis Paraskevopoulos
Giannis Paraskevopoulos

Reputation: 18411

SELECT    * 
FROM      ForceInstance FI 
          INNER JOIN Force F 
              ON FI.ForceID = F.ForceID 
          INNER JOIN ForceType FT
              ON F.ForceTypeID = FT.ForceTypeID

Upvotes: 1

Mikhail Timofeev
Mikhail Timofeev

Reputation: 2169

Select * from ForceInstance FI 
inner join Force F on  FI.ForceID = F.ForceID
inner join ForceType FT on F.ForceTypeID = FT.ForceTypeID

Upvotes: 1

Related Questions