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
обсуждение исходный текст
Ответы 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?"  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-general
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 по дате отправления:

Предыдущее
От: Phil Jackson
Дата:
Сообщение: Re: Cannot open table in new database
Следующее
От: Chris Browne
Дата:
Сообщение: Re: Postgres table contents versioning