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 Lush||Date: 2011-12-08 12:55:38|
|Subject: big wide table|
|Previous:||From: Bret Fledderjohn||Date: 2011-12-08 03:44:40|
|Subject: Re: Basic Query Question|