Group by problem

Hi,

I tried to execute the following statement

SELECT Po_No, Po_Com_code

FROM POAPInvRelate

WHERE Inv_Com_Code = '002' AND Inv_No = '5'

GROUP BY 1, 2

However, did not work. Because, I need to put columns names instead:

GROUP BY Po_No, Po_Com_code

In this case works well.

Does it mean I need to use columns names?

can I not use columns reference numbers?

cheers,

hello alex,

you can't do that in group by

that syntax belongs to

"order by " such as

order by 1, 2

regards,

joey

|||Thanks joey