[thelist] SQL: finding records whose most recent status is...

Matt Warden mwarden at gmail.com
Fri Jun 9 00:44:00 CDT 2006


-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

Judah McAuley wrote:
> So consider the situation where there are, say, 3 statuses: New, Pending 
> and Complete and I want to find all the orders that are currently Pending.

Then you want to find all records where there exists a status record of
'pending' but there does not exist a status record of 'complete'.

Does that point you in the right direction?

- --
Matt Warden
Oxford, OH, USA
http://mattwarden.com


This email proudly and graciously contributes to entropy.
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.2.2 (GNU/Linux)
Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org

iD8DBQFEiQqgrI3LObhzHRMRAspPAJ9J8ZJlXAAnRIly3fjsvTbNN8A0ywCdH2ft
yEUli7c7W01IEmB9yNJhVG0=
=w1Fs
-----END PGP SIGNATURE-----



More information about the thelist mailing list