Ambiguous columns

If I have two tables(taba, tabb) with the same column (column1) name and
try to do:

SELECT taba.column1 AS column1,tabb.column2 AS column2
    FROM taba AS a
         JOIN tabb AS b
         ON  taba.indexCol = tabb.indexCol
GROUP BY column1

It tells me that column1 is ambiguous. Is that to be expected? I can
semi see why - but I thought you could only only group on selected
fields, and the only 'selected' column1 is that from taba. Minor issue,
with easy work around.
--


Regards,

Steve Tucknott
ReTSol Ltd

DDI    01903 828769
MOBILE    07736715772





___________________________________________________________
Yahoo! Messenger - NEW crystal clear PC to PC calling worldwide with voicemail http://uk.messenger.yahoo.com