Re: sql problem
Date: Thu, 20 Mar 2008 07:25:11 +0100
On Wed, 19 Mar 2008 20:47:32 -0700 (PDT), marfi95 <marfi95_at_yahoo.com> wrote:
>So, for example, Table1 could have 2
>rows per key, while Table2 could have 3 rows per key.
This means your so-called 'key' is not a key. Your design is fundamentally flawed.
You can not hope to correct your flawed and incorrect design by using SQL.
What you need is a box with straws, and some underpaid minions drawing them to get the 'information' (which is no information at all, but a proper mess) you require.
-- Sybrand Bakker Senior Oracle DBAReceived on Thu Mar 20 2008 - 01:25:11 CDT