[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