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 [EMAIL PROTECTED] * andrew_perrin (at) unc.edu -- TriLUG mailing list : http://www.trilug.org/mailman/listinfo/trilug TriLUG Organizational FAQ : http://trilug.org/faq/ TriLUG Member Services FAQ : http://members.trilug.org/services_faq/ TriLUG PGP Keyring : http://trilug.org/~chrish/trilug.asc
