in reply to [untitled node, ID 178308]
it'll work faster, and there's no bind params or overwriting the statement handle to worry about.select a.id,a.body,b.count(*) from news a, comments b where a.id = b.id(+) group by a.id,a.body
note: the (+) is the outer join operator in Oracle, change it to whatever's required in the RDBMS you use
rdfield
|
|---|