using where and inner join in mysql

Question

I have three tables   locations  ID     NAME   TYPE   1      add1   stat   2      add2   coun    3      add3   coun   4      add4   coun    5      add5   stat      schools   ID   NAME    1    sch1       2    sch2  3   sch3    school locations   ID  LOCATIONS ID  SCHOOL ID  1    1            1  2    2            2  3    3            3   Here the table locations contains all the locations of the application Locations for school are called by ID s   when i use the query  select locations name from locations where type  coun     it displays names with type  coun   But I want to display locations name where only school locations have type  coun   i tried following queries  but none seems to be working  select locations name  from locations  where type  coun   inner join school locations     on locations id school locations location id  inner join schools     on school locations school id schools id    and  select locations name  from locations  inner join school locations     on locations id school locations location id  inner join schools     on school locations school id schools id  where type  coun     is it possible to use multiple inner joins in queries  or is there another way

User · Accepted Answer

SELECT  locations   name        FROM  locations  INNER JOIN  school locations          ON  locations   id     school locations   location id  INNER JOIN  schools          ON  school locations   school id     schools id       WHERE  type     coun     the WHERE clause has to be at the end of the statement

User · Answer

Try this    SELECT             SELECT            NAME        FROM           locations       WHERE           ID   school locations LOCATION ID       as  NAME  FROM      school locations WHERE              SELECT            TYPE        FROM           locations       WHERE           ID   school locations LOCATION ID           coun

User · Answer

You can use as many joins as you want  however  the more you use the more it will impact performance

User · Answer

Try this   SELECT Locations Name  Schools Name FROM Locations INNER JOIN School Locations ON School Locations Locations Id   Locations Id INNER JOIN Schools ON School Id   Schools Locations School Id WHERE Locations Type    coun    You can join Locations to School Locations and then School Locations to School   This forms a set of all related Locations and Schools  which you can then widdle down using the WHERE clause to those whose Location is of type  coun

[mysql] using where and inner join in mysql

Examples related to mysql

Examples related to inner-join