From: | greg(at)turnstep(dot)com |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Cc: | tony(at)tgds(dot)net |
Subject: | Re: sub select madness |
Date: | 2003-03-06 15:59:33 |
Message-ID: | 0161613ec2fb54425984d59443adcb05@biglumber.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1
I think what you want is this (I used 'Jill' not 'John'
as in your example because John has no expos in the
sample data)
SELECT a.artist_name, e.expo_number, e.exponame
FROM artist a, expo e, expo_artist ea
WHERE a.artist_name= 'Jill'
AND a.artist_number = ea.artist_number
AND e.expo_number = ea.expo_number
- --
Greg Sabino Mullane greg(at)turnstep(dot)com
PGP Key: 0x14964AC8 200303061053
-----BEGIN PGP SIGNATURE-----
Comment: http://www.turnstep.com/pgp.html
iD8DBQE+Z28bvJuQZxSWSsgRAm4PAKCeUHlD7VgkIo4edAEgsERQPwApeACgywR4
VAc52mvNjrxApy4BtElZqow=
=bJXQ
-----END PGP SIGNATURE-----
From | Date | Subject | |
---|---|---|---|
Next Message | Lonni J Friedman | 2003-03-06 16:13:53 | pg_restore problem |
Previous Message | Bruce Momjian | 2003-03-06 15:56:22 | Re: What filesystem? |