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
--
"None are more hopelessly enslaved than those who falsely believe they
are free" -- Johann Wolfgang von Goethe