[SOLVED] MySQL Inner Join Not Working

[cheechm]

Why doesn't this query work?

 

SELECT q.qid, q.cid, q.status, c.name, c.company FROM quote AS q INNER JOIN customers AS c USING (cid) WHERE q.cid = 128

 

It shows every result from quote and customers instead of just the ones where quotes.cid = 128.

 

Thanks

[wildteen88]

I think you'll need group the results by the matching column.

 

Eg

SELECT q.qid, q.cid, q.status, c.name, c.company FROM quote AS q INNER JOIN customers AS c USING (cid) WHERE q.cid = 128 GROUP BY q.cid

 

Moved to MySQL Help.

[cheechm]

Nope doesn't seem to work.

 

Thanks anyway.

[F1Fan]

SELECT q.qid, q.cid, q.status, c.name, c.company FROM quote AS q, customers AS c WHERE q.cid = c.cid AND q.cid = 128 GROUP BY q.cid