SQL Inner join more than two tables

Question

I can currently query the join of two tables on the equality of a foreign primary key in the following way     result   mysql query  SELECT   FROM  table1                            INNER JOIN                          table2  ON table1 primaryKey table2 table1Id      I d like to extend this to multiple tables  all with the same foreign keys   I am trying the following code which is not returning anything  Can anyone point out what I m doing wrong     result   mysql query  SELECT   FROM  table1                           INNER JOIN  table2                           INNER JOIN table3                          ON table1 primaryKey table2 table1Id table3 table1Id

User · Answer

Please find inner join for more than 2 table here

Here are 4 table name like

Orders
Customers
Student
Lecturer

So the SQL code would be:

select o.orderid, c.customername, l.lname, s.studadd, s.studmarks 
from orders o 
    inner join customers c on o.customrid = c.customerid 
    inner join lecturer l  on o.customrid = l.id 
    inner join student s   on o.customrid=s.studmarks;

User · Answer

Try this Here the syntax is SELECT table1  columnName  table3  columnName     FROM table1       inner join table2            ON table1 primarykey   table2 foreignkey       inner join table3            ON table2 primarykey   table3 foreignkey  for example  Select SalesHeader invoiceDate ActualSales DeptName tblInvDepartment DeptCode  LocationCode from SalesDetail Inner Join SalesHeader on SalesDetail InvoiceNo   SalesHeader InvoiceNo inner join tblInvDepartment on tblInvDepartment DeptCode   SalesDetail DeptCode

User · Answer

The right syntax is like   SELECT   FROM table1 INNER JOIN table2 ON table1 primaryKey   table2 ForeignKey INNER JOIN table3 ON table3 primaryKey   table2 ForeignKey   Orthe last line joining table3 on table1 like   ON table3 ForeignKey  table1 PrimaryKey

User · Answer

select   from Employee inner join  Order   On Employee Employee id  Order  Employee id inner join Book  On Book Book id  Order  Book id inner join Book Author On Book Author Book id Book Book id inner join Author On Book Author Author id Author Author id

User · Answer

SELECT eb n EmpId     em s EmpName     deg s DesignationName     dm s DeptName FROM tbl EmployeeMaster em  INNER JOIN tbl DesignationMaster deg ON em n DesignationId deg n DesignationId  INNER JOIN tbl DepartmentMaster dm ON dm n DeptId   em n DepartmentId  INNER JOIN tbl EmployeeBranch eb ON eb n BranchId   em n BranchId

User · Answer

A possible solution   SELECT Company Company Id Company Company Name      Invoice Details Invoice No  Product Details Price   FROM Company inner join Invoice Details     ON Company Company Id Invoice Details Company Id  INNER JOIN Product Details         ON Invoice Details Invoice No  Product Details Invoice No  WHERE Price  60000     -- tets changes

User · Answer

SELECT    FROM table1  INNER JOIN table2       ON table1 primaryKey table2 table1Id INNER JOIN table3       ON table1 primaryKey table3 table1Id

User · Answer

Here is a general SQL query syntax to join three or more table  This SQL query should work in all major relation database e g  MySQL  Oracle  Microsoft SQLServer  Sybase and PostgreSQL    SELECT t1 col  t3 col FROM table1 join table2 ON table1 primarykey   table2 foreignkey                                   join table3 ON table2 primarykey   table3 foreignkey   We first join table 1 and table 2 which produce a temporary table with combined data from table1 and table2   which is then joined to table3  This formula can be extended for more than 3 tables to N tables  You just need to make sure that SQL query should have N-1 join statement in order to join N tables  like for joining two tables we require 1 join statement and for joining 3 tables we need 2 join statement

User · Answer

select WucsName as WUCS Name Year Tot Households Tot Households Tot Male Farmers  from tbl Gender INNER JOIN tblWUCS ON tbl Gender WUCS id  tblWUCS  WucsId  INNER JOIN tblYear ON tbl Gender YearID tblYear yearID   There are 3 Tables  1  tbl Gender  2  tblWUCS  3  tblYear

User · Answer

try this method given below  modify to suit your need   SELECT   employment status staff type    COUNT monthly pay register age     monthly pay register BASIC SALARY    monthly pay register TOTAL MONTHLY ALLOWANCES    monthly pay register MONTHLY GROSS    monthly pay register TOTAL MONTHLY DEDUCTIONS    monthly pay register MONTHLY PAY FROM     monthly pay register INNER JOIN deduction logs  ON   monthly pay register employee info employee no   deduction logs employee no  INNER JOIN   employment status ON deduction logs employee no   employment status employee no WHERE   monthly pay register  YEAR  2017 and    monthly pay register  MONTH   may

[sql] SQL Inner join more than two tables

Examples related to sql

Examples related to inner-join