inner join between 3 tables

Question

i have these table in database:

country:

id      country
------------------
1       USA
2       Brazil

and segment table:

id      country
------------------
1       USA
2       Brazil

i have a third table:

Id segment_id country_id

where segment_id is a foreign key of id in segment table

and country_id is a foreign key of id in country table

myquestion is:

how to select from the other table with inner join of the 3 tables,

i need to show the name of the country plus for every country show all the segments in a dropdown menu if anyone could help me

thank u

yes but it not working so i need the solution please thank u @TimBiegeleisen — eddy abikhalil, May 09 '17 at 09:32
If you tried something, post it here so others can take a look. — bisma, May 09 '17 at 12:07

score 0 · Answer 1 · answered May 09 '17 at 09:37

0

you just try this

$sql = select * from third_table 
       inner join country on third_table.country_id = country.id
       inner join segment on third_table.segment_id = segment.id
$res = mysql_query($sql);

   'or'


   select * from TableA A 
   inner join TableB B on A.Column=B.Column 
   inner join TableC C on A.Column=C.Column

answered May 09 '17 at 09:37

Andrew

840
3
17
43

1

[Please neither recommend using nor use `mysql_*()` functions](http://stackoverflow.com/q/12859942/2298301). They've been deprecated long ago and aren't a part of the build in PHP 7.0 and higher. – Dhruv Saxena May 09 '17 at 12:17

score 0 · Answer 2 · answered May 09 '17 at 09:43

0

SELECT * 
FROM third_table t
INNER JOIN country c ON t.country_id = c.country_id
INNER JOIN segment s ON t.segment_id = s.segment_id

answered May 09 '17 at 09:43

Ashu

1,320
2
10
24

score 0 · Answer 3 · answered May 09 '17 at 11:29

try this query.. this will help you to create list

select countrysegments.id as countrysegmentsID, country.country as countryName,
segment.country as segmentName
from countrysegments 
       inner join country on countrysegments.country_id  = country.id
       inner join segment on countrysegments.segment_id = segment.id

inner join between 3 tables

3 Answers3

Linked

Related