From: | Bryce Nesbitt <bryce1(at)obviously(dot)com> |
---|---|
To: | pgsql-sql(at)postgresql(dot)org |
Subject: | Syntax question: use of join/using with fully qualified table name |
Date: | 2008-01-28 00:49:24 |
Message-ID: | 479D2694.3090202@obviously.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-sql |
I've got a join where a certain column name appears twice:
select username,last_name from eg_member join eg_membership using
(member_id) join eg_account using (account_id) join eg_person using
(person_id);
ERROR: common column name "person_id" appears more than once in left table
My first inclination was to fully quality the table name. Why would
this not be acceptable syntax?
select username,last_name from eg_member join eg_membership using
(member_id) join eg_account using (account_id) join eg_person using
(eg_member.person_id);
ERROR: syntax error at or near "." at character 145
Of course I eventually wrote it:
select username,last_name from eg_member join eg_membership using (member_id) join eg_account using (account_id) join eg_person on eg_member.person_id=eg_person.person_id';
PostgreSQL 8.1.9 on i686-redhat-linux-gnu, compiled by GCC gcc (GCC) 4.1.1 20070105 (Red Hat 4.1.1-51)
--
----
Visit http://www.obviously.com/
From | Date | Subject | |
---|---|---|---|
Next Message | Martin Marques | 2008-01-28 01:43:04 | Re: Syntax question: use of join/using with fully qualified table name |
Previous Message | Andrej Ricnik-Bay | 2008-01-25 23:05:47 | Re: Extract interdependent info from one table |