mysql join query

Question

I have 2 tables like this

Table 1

id name
1 ABC
2 DEF
3 GEF


Table 2
name meal
ABC  m1
ABC  m2
GEF  m1

Table 3
meal detail
m1   mutton
m2   beaf

How can I get output like this?

Id name meal_detail
1  ABC  mutton,beaf
2  DEF
3  GEF  mutton

Thanks in Advance

zerkms · Accepted Answer · 2010-10-27 00:13:58Z

3

   SELECT t1.id,
          t1.`name`,
          GROUP_CONCAT(t3.detail) AS `meal_detail`
     FROM t1
LEFT JOIN t2 ON t2.`name` = t1.`name`
LEFT JOIN t3 ON t3.meal = t2.meal
 GROUP BY t1.`name`

answered Oct 27, 2010 at 0:13

zerkms

256k73 gold badges447 silver badges551 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

zerkms Over a year ago

@OMG Ponies: nah, now I follow your formatting style everywhere ;-) Just cheated with saving correct but not formatted query to catch the first answer ;-P

zerkms Over a year ago

@EarnWhileLearn: lucky me ;-)

Collectives™ on Stack Overflow

mysql join query

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related