| From: | Steve Tucknott <steve(at)retsol(dot)co(dot)uk> |
|---|---|
| To: | PostGreSQL <pgsql-novice(at)postgresql(dot)org> |
| Subject: | Ambiguous columns |
| Date: | 2005-07-03 07:17:01 |
| Message-ID: | 1120375022.1326.11.camel@retsol1 |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | 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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Andreas Kretschmer | 2005-07-03 08:42:19 | Re: [despammed] Ambiguous columns |
| Previous Message | Steve Poe | 2005-07-03 05:50:02 | Re: General Question |