Re: sql problem

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 DBA