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!
In response to
pgsql-novice by date
|Next:||From: Jude Lucien||Date: 2011-12-07 21:15:42|
|Subject: Re: Basic Query Question|
|Previous:||From: Jude Lucien||Date: 2011-12-07 20:55:28|
|Subject: Basic Query Question|