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.
Related examples in the same category