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
