Mega Code Archive

 

Categories / Oracle PLSQL / Table Joins

 

Join using clause

SQL> CREATE TABLE emp(   2     cid                NUMBER,   3     postal_code           VARCHAR2(10),   4     city              VARCHAR2(30),   5     customer_state             VARCHAR2(40),   6     country_id                 CHAR(2),   7     customer_credit            NUMBER,   8     email                 VARCHAR2(30)   9  ); Table created. SQL> SQL> CREATE TABLE sales(   2    product_id                  NUMBER(6),   3    cid                 NUMBER,   4    time_id                     DATE,   5    channel_id                  CHAR(1),   6    promo_id                    NUMBER(6),   7    sold               NUMBER(3),   8    amount                      NUMBER(10,2),   9    cost                        NUMBER(10,2)  10  ); Table created. SQL> SQL> SQL> select cid, c.customer_state,s.sold   2  from sales s join emp c   3  using (cid)   4  where product_id = 117; no rows selected SQL> SQL> drop table sales; Table dropped. SQL> drop table emp; Table dropped.