Re: Basic Query Question
| От | Bret Fledderjohn |
|---|---|
| Тема | Re: Basic Query Question |
| Дата | |
| Msg-id | CAKxkEFbjsdLFfHK-gkBku_9XZ-xaV=0qv7ch_QBs2ZyjgL3P7Q@mail.gmail.com обсуждение исходный текст |
| Ответ на | Re: Basic Query Question (Jude Lucien <jlucien@gmail.com>) |
| Ответы |
Re: Basic Query Question
|
| Список | pgsql-novice |
Hi Jude,
- Bret
____________________________________________
"Why should I fret in microcosmic bonds
That chafe the spirit, and the mind repress,
When through the clouds gleam beckoning beyonds
Where shining vistas mock man's littleness?"
- H.P. Lovecraft, "Phaeton" (1918)
On 7 December 2011 16:35, Jude Lucien <jlucien@gmail.com> wrote:
-- SELECT DISTINCT bike.bike_id FROM bike WHERE bike.model='Kona Dew SE
FRR' AND booking.booking_date='2011-11-20' JOIN booking ON
bike.bike_id=booking.bike_id;
returns a syntax error at JOIN
JOIN is in the wrong location. Needs to be before the WHERE clause.
SELECT DISTINCT bike.bike_id FROM bike LEFT JOIN booking ON
bike.bike_id = booking.bike_id AND booking.booking_date <>
'2011-11-20' WHERE bike.model = 'Kona Dew SE FRR';
You're comparing the booking_date in the JOIN and you should be doing this in the WHERE clause since that will select only the booking.bike_id's rented on all other dates.
returns 23 results - two of those results have a booking date of
2011-11-20, so it should return 21 results.
Cheers
- Bret
____________________________________________
"Why should I fret in microcosmic bonds
That chafe the spirit, and the mind repress,
When through the clouds gleam beckoning beyonds
Where shining vistas mock man's littleness?"
- H.P. Lovecraft, "Phaeton" (1918)
В списке pgsql-novice по дате отправления: