Ambiguous columns

Поиск
Список
Период
Сортировка
От Steve Tucknott
Тема Ambiguous columns
Дата
Msg-id 1120375022.1326.11.camel@retsol1
обсуждение исходный текст
Ответы Re: [despammed] Ambiguous columns  (Andreas Kretschmer <akretschmer@despammed.com>)
Re: Ambiguous columns  (Tom Lane <tgl@sss.pgh.pa.us>)
Re: Ambiguous columns  (Bruno Wolff III <bruno@wolff.to>)
Re: Ambiguous columns  (Jeffrey Melloy <jmelloy@visualdistortion.org>)
Список pgsql-novice
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

В списке pgsql-novice по дате отправления:

Предыдущее
От: Steve Poe
Дата:
Сообщение: Re: General Question
Следующее
От: Andreas Kretschmer
Дата:
Сообщение: Re: [despammed] Ambiguous columns