Skip site navigation (1) Skip section navigation (2)

Re: What am I doing wrong?

From: John Poltorak <jp(at)eyup(dot)org>
To: pgsql-novice(at)postgresql(dot)org
Subject: Re: What am I doing wrong?
Date: 2001-01-17 12:29:31
Message-ID: 20010117122931.Q85@eyup.org (view raw or flat)
Thread:
Lists: pgsql-novice
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



In response to

pgsql-novice by date

Next:From: Nabil SayeghDate: 2001-01-17 12:51:54
Subject: Re: Nested Queries
Previous:From: Luke Tudor - RSGDate: 2001-01-17 12:16:34
Subject: Nested Queries

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group