Re: [Oracle] Sql request

From: Ben Finney <bignose+hates-spam_at_benfinney.id.au>
Date: Sat, 28 Nov 2009 11:36:38 +1100
Message-ID: <87bpinwkmh.fsf_at_benfinney.id.au>

Thomas Kellerer <OTPXDAJCSJVU_at_spammotel.com> writes:

> And even if the "blank" stuff should be in there I don't understand
> the complicated sub-query you were using :)

For didactic purposes. I prefer to have attribute names that make sense in the context of the relation; and then use attribute renames in the select so that a natural join will just work. Join conditions give me hives; every join should be natural anyway :-)

-- 
 \        “I fly Air Bizarre. You buy a combination one-way round-trip |
  `\    ticket. Leave any Monday, and they bring you back the previous |
_o__)     Friday. That way you still have the weekend.” —Steven Wright |
Ben Finney

Received on Fri Nov 27 2009 - 18:36:38 CST