Actually it does work slightly modified - here's the query that works for my application:
leted=# Select s.partid, s.zip, c.coder, c.ca_date, c.tone_angry leted-# from participants s,code_assignments c leted-# where c.ca_partid = s.partid leted-# and c.ca_date = (select min(c2.ca_date) from code_assignments c2 where c.ca_partid=c2.ca_partid) leted-# ; Thanks! Andy ---------------------------------------------------------------------- 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
