Reputation: 1011

MySql Join tables

I have two tables like this.

Table 1 Fields: CId , Name Table 2 Fields: CId , food

I want to get no. of food against each CId with the query "select * from table1"

Upvotes: 0

Answers (3)

Reputation: 10880

Something like that should work:

SELECT
  t1.* , count(t2.food) as foods
FROM
  t1 LEFT JOIN t2 on (t1.Cid = t2.Cid)
GROUP BY
  t2.Cid

Upvotes: 1

Reputation: 26732

select a.name, b.food from table1 a, table1 b where a.cld = b.cld;

Upvotes: 1

Reputation: 191749

SELECT
   food
FROM
   Table2 t2
   JOIN Table1 t1 ON (t2.Cld = t1.Cld)

Upvotes: 1