Re: sub select madness - Mailing list pgsql-general

From greg@turnstep.com
Subject Re: sub select madness
Date
Msg-id 0161613ec2fb54425984d59443adcb05@biglumber.com
Whole thread Raw
In response to Re: sub select madness  ("Carl Olivier" <carl@zero-one.co.za>)
List 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@turnstep.com
PGP Key: 0x14964AC8 200303061053
-----BEGIN PGP SIGNATURE-----
Comment: http://www.turnstep.com/pgp.html

iD8DBQE+Z28bvJuQZxSWSsgRAm4PAKCeUHlD7VgkIo4edAEgsERQPwApeACgywR4
VAc52mvNjrxApy4BtElZqow=
=bJXQ
-----END PGP SIGNATURE-----



pgsql-general by date:

Previous
From: Bruce Momjian
Date:
Subject: Re: What filesystem?
Next
From: Lonni J Friedman
Date:
Subject: pg_restore problem