On Wed, Jan 17, 2001 at 12:08:35PM +0000, John Poltorak wrote:
> On Thu, Jan 18, 2001 at 12:29:42AM +1300, Andrew McMillan wrote:
> > test=# SELECT player, club from players natural join clubs;
> This works fine and it's simpler.
> BTW how do I limit this select to players from 'Juve' ?
> I tried appending "where club = 'Juve'", but this returned 0 rows...
It does work, when you type it correctly :-).
In response to
pgsql-novice by date
|Next:||From: Nabil Sayegh||Date: 2001-01-17 12:51:54|
|Subject: Re: Nested Queries|
|Previous:||From: Luke Tudor - RSG||Date: 2001-01-17 12:16:34|
|Subject: Nested Queries|