Re: Basic Query Question

On 7 December 2011 16:58, Jude Lucien <jlucien(at)gmail(dot)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?
>

UNION[ALL] See this
http://www.postgresql.org/docs/9.0/interactive/queries-union.html

> 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)