[TriLUG] Any SQL experts out there?

[Andrew Perrin]

On Fri, 25 Feb 2005, Paul Damer wrote:

...
> How about something along the lines of:
>
> Select s.partid, s.age,  c.coder, c.ca_date, c.tone_angry
> from subjects s, code_assignments c
> where c.partid = s.partid
> and c.ca_date = (select min(c2.ca_date) where c.partid = c2.partid)
>

Thanks - that returns:

ERROR:  relation "c2" does not exist


----------------------------------------------------------------------
Andrew J Perrin - http://www.unc.edu/~aperrin
Assistant Professor of Sociology, U of North Carolina, Chapel Hill
clists at perrin.socsci.unc.edu * andrew_perrin (at) unc.edu