Re: Basic Query Question

try it out and let us know.
we anxiously await your reply ;-)

On 12/7/11 4:15 PM, Jude Lucien wrote:
> I've just realised why it may not be working - bike_id is not the
> primary key of booking.  booking_id is.
>
> I was getting results, just not the correct ones.  There are 23 bikes
> of a certain model, two of which are booked on a certain date.  My
> query should then return 21 bike_id's.
>
> Can I even do a join if booking.bike_id is not the primary key?
>
>
> On 7 December 2011 21:02, Ramy Abdel-Azim
> <ramy.abdel-azim@startdatelabs.com>  wrote:
>> 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
>>>
>>>
>>>
>>
>> --
>> Sent via pgsql-novice mailing list (pgsql-novice@postgresql.org)
>> To make changes to your subscription:
>> http://www.postgresql.org/mailpref/pgsql-novice
>
>