12-16-2009, 10:55 AM
|
#9 (permalink)
|
|
The Visitor
Join Date: Dec 2009
Posts: 1
Thanks: 0
|
poor example, but here is how i do it.
Code:
SELECT t1.col1, t1.col2, t3.col3
FROM tab1 as t1, tab2 as t2
LEFT JOIN tab3 as t3 on t3.colx = t1.col1
WHERE t1.col1 = cond1
AND t1.col2 = cond2
GROUP BY t1.col1, t1.col2
ORDER BY t1.col1, t1.col2 ASC
HAVING func(t1.col1)
|
|
|
|