Skip site navigation (1) Skip section navigation (2)

Re: Basic Query Question

From: Jude Lucien <jlucien(at)gmail(dot)com>
To: Bret Fledderjohn <freelancer317(at)gmail(dot)com>
Cc: pgsql-novice(at)postgresql(dot)org
Subject: Re: Basic Query Question
Date: 2011-12-08 11:15:10
Message-ID: CAPRXF2oTY5uuYFrSMznEZaPxmOEWe8D_t-xVQ3oS1iP22tiRzA@mail.gmail.com (view raw or flat)
Thread:
Lists: pgsql-novice
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

In response to

Responses

pgsql-novice by date

Next:From: Michael LushDate: 2011-12-08 12:55:38
Subject: big wide table
Previous:From: Bret FledderjohnDate: 2011-12-08 03:44:40
Subject: Re: Basic Query Question

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group