Re: [SQL] Syntax question: use of join/using with fully qualified table name

Bryce Nesbitt <[EMAIL PROTECTED]> writes: > 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" ap

Re: [SQL] Syntax question: use of join/using with fully qualified table name

Bryce Nesbitt escribió: 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 l

[SQL] Syntax question: use of join/using with fully qualified table name

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 incli