[RESOLVED] where to add the WHERE clause

[fr8]

No matter where I add the "WHERE" clause it errors on me. But if I leave it alone it pulls everything in the DB just fine. using MySql.

The SQL for the WHERE is "WHERE mm_bl.bid = 1002"

SELECT mm_bl. * , mm_h.name, mm_p.pname
FROM mm_bl
INNER JOIN mm_h ON mm_bl.oid = mm_h.oid
LEFT OUTER JOIN mm_p ON mm_bl.mid = mm_p.mid
GROUP BY mm_bl.bid

[fr8]

droped the GROUP BY clause and it works.

[bpat1434]

Well that doesn't answer your question, but I do know 1 document (or set of documents) that will indefinately answer any syntax questions you may have about where certain things fall within the query... I'll give you a hint... it's online, in PDF Format, and you can probably purchase a paper copy of it... it's the MySQL Manual!!!

mySQL Manual :: Select Syntax

~Brett

[fr8]

Yes that did answer my question. By droping the GROUP BY and adding the WHERE it worked. The result it gave is what i needed.

It did not answer my question if you mean by that you can have the GROUP BY in the sql that i have.

Yes I have it bookmarked.