Thanks all, I have my one query all figured out.
I was struggling, I appreciate your help!
On 8 December 2011 03:44, Bret Fledderjohn <freelancer317@gmail.com> wrote:
>
>
> 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?
>
>
> 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)
--
"None are more hopelessly enslaved than those who falsely believe they
are free" -- Johann Wolfgang von Goethe