Re: left outer join fails because "column .. does not exist in left table?"

On Wed, Jun 30, 2010 at 7:01 PM,  <Rick.Casey@colorado.edu> wrote:
> 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...

Capitalization maybe?  pgsql folds to lower case.