Re: [despammed] Ambiguous columns

am 03.07.2005, um 8:17:01 +0100 mailte Steve Tucknott folgendes:
> 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

untestet:

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

Regards, Andreas
--
Andreas Kretschmer (Kontakt: siehe Header)
Heynitz: 035242/47212, D1: 0160/7141639
GnuPG-ID 0x3FFF606C http://wwwkeys.de.pgp.net
=== Schollglas Unternehmensgruppe ===