Re: Basic Query Question

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(at)gmail(dot)com> wrote:
>
>
> 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)

--
"None are more hopelessly enslaved than those who falsely believe they
are free"  -- Johann Wolfgang von Goethe