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...
Oops!
It does work, when you type it correctly :-).
--
John