Subject | group by doesn't work |
---|---|
Author | guntersammet |
Post date | 2002-01-06T19:55:50Z |
I tried to execute following sql statement and a get an invalid
column reference error:
SELECT table1.column1,table1join.joinColumn1,table1join.joinColumn2
FROM table1 LEFT OUTER JOIN table1join ON
table1.column1=table1join.joinColumn0 WHERE table1.column1 >= 0
GROUP BY table1.column1
Any suggestions? TIA
Gunter
column reference error:
SELECT table1.column1,table1join.joinColumn1,table1join.joinColumn2
FROM table1 LEFT OUTER JOIN table1join ON
table1.column1=table1join.joinColumn0 WHERE table1.column1 >= 0
GROUP BY table1.column1
Any suggestions? TIA
Gunter