Re: Problem with a view

From: Thomas Schwickert <schwickert_at_yahoo.com>
Date: Mon, 10 Sep 2001 10:21:11 +0000 (UTC)
Message-ID: <a16744a8be49f484e0b9838515591434.20305@mygate.mailgate.org>

Hi,

"Ben-oui" <aslamette_at_free.fr> wrote in message news:4L%m7.1697$tP.2105373_at_nnrp5.proxad.net...
>
> I create a view by :
>
> WHERE
> (b.table_name like 'PREFIXE%'
> AND b.column_name = c.column_name)
> ORDER BY b.table_name
>
> When I execute the view, Oracle returns a column is displayed several time
> and I don't understand why ?

you are joining to tables, so you have to match all matching colons:

   WHERE
          b.owner = c.owner

  and  b.table_name = c.table_name
  and  b.column_name = c.column_name
  and  b.table_name like 'PREFIXE%'

  ORDER BY b.table_name

will do what you want ...
btw. you are not selecting the owner ...
>
> And, it returns the VIEWCOLONNES columns in this query ! Why ?
i don't understand this question ...

Hth
 Thomas  

-- 
Posted from  [212.20.131.226] 
via Mailgate.ORG Server - http://www.Mailgate.ORG

Received on Mon Sep 10 2001 - 05:21:11 CDT