CODEWITHSUNDEEP
phpmysql
kks
kks

Reputation: 21

mysql join 3 tables

How can I join three mysql tables which have one common column (id), For example, Select a, b from Table1, select c,d from table2, select e,f from table3, where id=x Thanks

Upvotes: 2

Views: 6300

Answers (6)

abhaySisodiya
abhaySisodiya

Reputation: 1

Please try this query:

SELECT product_details.product_id, product_name.pro_name,categories.cat_name
        FROM product_details
        INNER JOIN product_name
        ON product_details.product_id=product_name.id INNER JOIN categories ON product_details.categories_id=categories.id order by product_details.id;

Upvotes: 0

Imran Khan
Imran Khan

Reputation: 2401

 SELECT t1.a, t1.b, t2.c, t2.d, t3.e, t3.f
  FROM table1 t1
  JOIN table2 t2 ON (t1.id = t2.id) 
  JOIN table3 t3 ON (t1.id = t3.id)
  ORDER BY t1.id;

Upvotes: 9

Ricky Sharma
Ricky Sharma

Reputation: 1919

SELECT col1,col2,col3 (select any col from any table ) 
FROM t1 INNER JOIN t2,t3 
WHERE t1.id = t2.id
AND t1.id = t3.id;

Upvotes: 0

judda
judda

Reputation: 3972

SELECT t1.a, t1.b, t2.c, t2.d, t3.e, t3.f
FROM `table1` t1
JOIN `table2` t2 ON t1.id = t2.id
JOIN `table3` t3 ON t1.id = t3.id
WHERE t1.id = x

Upvotes: 3

Khalid Amin
Khalid Amin

Reputation: 902

SELECT t1.a, t1.b, t2.c, t2.d, t3.e, t3.f
  FROM table1 t1, table2 t2, table3 t3
 WHERE t1.id = t2.id
   AND t2.id = t3.id
   AND t3.id = x

Upvotes: 2

Emmerman
Emmerman

Reputation: 2343

SELECT `table1`.`a`,`table2`.`c` .....
FROM `table1` JOIN `table2` USING(`id`) JOIN `table3` USING(`id`)
WHERE `id` = x

Upvotes: 2

Related Questions