left outer join fails because "column .. does not exist in left table?"
От
Rick.Casey@colorado.edu
Тема
left outer join fails because "column .. does not exist in left
table?"
Дата
Msg-id
45037.128.138.153.24.1277938918.squirrel@ibg.colorado.edu
Список
Дерево обсуждения
left outer join fails because "column .. does not exist in left
table?" Rick.Casey@colorado.edu
Re: left outer join fails because "column .. does not exist in left table?" Tom Lane <tgl@sss.pgh.pa.us>
Re: left outer join fails because "column .. does not exist
in left table?" Scott Marlowe <scott.marlowe@gmail.com>
Re: left outer join fails because "column .. does not exist
in left table?" Scott Marlowe <scott.marlowe@gmail.com>
I have a JOIN error that is rather opaque...at least to me. I've using other JOIN queries on this project, which seem very similar to this one, which looks like: SELECT S.subjectid,STY.studyabrv,labID,boxnumber,wellrow,wellcolumn FROM DNASample D, IBG_Studies STY, Subjects S, ibg_projects P LEFT OUTER JOIN ibg_ps_join IPJ USING (dnasampleid) WHERE D.subjectidkey=S.id AND STY.studyindex=D.studyindex AND IPJ.projects_index=P.ibg_projects_index ORDER BY studyabrv,boxnumber,wellcolumn,wellrow But when I run it I get this error: ERROR: column "dnasampleid" specified in USING clause does not exist in left table I am rather mystified by this, since this field is definitely in the dnasample table, as the primary key. Nor do not see how to start debugging such an error. Any suggestions appreciated... --Rick
В списке pgsql-general по дате отправления