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: (view raw, whole thread or download thread mbox)
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...


It does work, when you type it correctly :-).


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-2017 The PostgreSQL Global Development Group