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: (view raw, whole thread or download thread mbox)
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
>> 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


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-2017 The PostgreSQL Global Development Group