Re: [Oracle] Sql request

From: Ben Finney <>
Date: Sat, 28 Nov 2009 11:36:38 +1100
Message-ID: <>

Thomas Kellerer <> 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

Original text of this message