On Wed, Jun 30, 2010 at 7:01 PM, <Rick(dot)Casey(at)colorado(dot)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)
> 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.
In response to
pgsql-general by date
|Next:||From: Michael Glaesemann||Date: 2010-06-30 23:27:26|
|Subject: Re: Can't EXTRACT number of months from an INTERVAL|
|Previous:||From: Rick.Casey||Date: 2010-06-30 23:01:58|
|Subject: left outer join fails because "column .. does not exist in left