4 Replies Latest reply: Feb 20, 2013 3:07 PM by kendenny RSS

    Am I using a LOV? (ambiguously defined column)

    982108
      I have two tables:
      create table products (prod_cd varchar (10) , prod_desc varchar2(20)); /
      create table cases (case_id varchar(20), client_desc varchar(20), client_id varchar(20)) /
      The cliient_id of cases table matches the prod_cd of the products table. The client desc = prod_desc.

      I have this kind of data in the products table

      PROD_CD PROD_DESC
      1 Fish R Us
      2 Tanning Oils Inc
      3 Jane but Sane

      However, if I try this query
      selelct prod_cd, client_id
      from products, cases
      where prod_cd = client_id
      Fails...

      ORA-00918: column ambiguously defined
      00918. 00000 - "column ambiguously defined"
      *Cause:   
      *Action:
      Error at Line: 7 Column: 7

      I think prod_cd is a LOV. How can I get the vlaue out of it so my column inst ambiguously defined?