Mega Code Archive

 

Categories / Oracle PLSQL / Select Query

 

Use table name to reference the ambiguity column names

SQL> CREATE TABLE emp   2  (   3     cid                NUMBER,   4     address        VARCHAR2(40),   5     customer_state             VARCHAR2(40),   6     phone     VARCHAR2(25),   7     income_level          VARCHAR2(30),   8     customer_credit            NUMBER,   9     city              VARCHAR2(30)  10  ); Table created. SQL> SQL> CREATE TABLE sales(   2    product_id               NUMBER(6),   3    cid               NUMBER,   4    channel_id            CHAR(1),   5    sold         NUMBER(3),   6    cost                  NUMBER(10,2)   7  ); Table created. SQL> SQL> select product_id, sold, city, customer_state   2  from   sales s, emp c   3  where  s.cid = c.cid   4  and    product_id = 117; no rows selected SQL> SQL> select s.product_id, s.sold, c.cid,   2  c.city, c.customer_state   3  from   sales s, emp c   4  where  s.cid = c.cid   5  and    s.product_id = 117; no rows selected SQL> SQL> SQL> SQL> drop table emp; Table dropped. SQL> drop table sales; Table dropped.