[TriLUG] Any SQL experts out there?

[Andrew Perrin]

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
clists at perrin.socsci.unc.edu * andrew_perrin (at) unc.edu