Join using clause : Table Join Column « Table Joins « Oracle PL / SQL

1. Oracle PL / SQL
2. Table Joins
3. Table Join Column

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.

   
    
  

Related examples in the same category