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

Re: Basic Query Question

From: Ramy Abdel-Azim <ramy(dot)abdel-azim(at)startdatelabs(dot)com>
To: pgsql-novice(at)postgresql(dot)org
Subject: Re: Basic Query Question
Date: 2011-12-07 21:02:31
Message-ID: 4EDFD467.9010903@startdatelabs.com (view raw or flat)
Thread:
Lists: pgsql-novice
i'm not sure but i think not being explicit about the join causes psql 
to try to join on ID.

What are you getting? an error or an empty result set?

I would think you should do the join explicitly like this:

select bike.bike_id from bike  join booking on bike.bike_id = 
booking.bike_id where booking.date != '2011-11-20'

On 12/7/11 3:55 PM, Jude Lucien wrote:
> Sorry for the basic question, I can't seem to figure it out.
>
> I have two tables, booking and bike.  Both have bike_id as primary key.
>
> I am trying to return all bike_id's where bike.model='Kona' AND
> booking.booking_date DOES NOT EQUAL 'date';
>
> My query is as follows:
>
> SELECT bike.bike_id FROM bike,booking WHERE bike.model='model' AND
> booking.booking_date!='2011-11-20' AND bike.bike_id=booking.bike_id;
>
> Any help appreciated!
>
> Jude
>
>
>


In response to

Responses

pgsql-novice by date

Next:From: Jude LucienDate: 2011-12-07 21:15:42
Subject: Re: Basic Query Question
Previous:From: Jude LucienDate: 2011-12-07 20:55:28
Subject: Basic Query Question

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