Re: Basic Query Question - Mailing list pgsql-novice

From Bret Fledderjohn
Subject Re: Basic Query Question
Date
Msg-id CAKxkEFZ6RscvPyev=dmsD5CYHEij7-vS_0CHdvRdr9gSSoFREQ@mail.gmail.com
Whole thread Raw
In response to Re: Basic Query Question  (Jude Lucien <jlucien@gmail.com>)
Responses Re: Basic Query Question
List pgsql-novice


On 7 December 2011 16:58, Jude Lucien <jlucien@gmail.com> wrote:
This is it.  There are other instances of bike_id in the booking
database that have different booking dates.

I can find bike_id's that match my specified booking date, but then I
need to run a second query to find the bike_id's that are not booked
on that date.

Is there any way to join the two queries into one?
Thanks for all the help so far.

- 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 by date:

Previous
From: Jude Lucien
Date:
Subject: Re: Basic Query Question
Next
From: Jude Lucien
Date:
Subject: Re: Basic Query Question