Two join on clauses : Equijoins « Table Joins « Oracle PL / SQL

1. Oracle PL / SQL
2. Table Joins
3. Equijoins

Two join on clauses

   

SQL> CREATE TABLE emp(
  2     cid                NUMBER,
  3     fname            VARCHAR2(20) ,
  4     city              VARCHAR2(30) ,
  5     customer_state             VARCHAR2(40),
  6     country_id                 CHAR(2) ,
  7     phone     VARCHAR2(25),
  8     income_level          VARCHAR2(30),
  9     customer_credit            NUMBER,
 10     email                 VARCHAR2(30)
 11  );

Table created.

SQL>
SQL> CREATE TABLE sales(
  2    product_id                  NUMBER(6),
  3    cid                 NUMBER,
  4    promo_id                    NUMBER(6),
  5    sold               NUMBER(3),
  6    amount                      NUMBER(10,2),
  7    cost                        NUMBER(10,2)
  8  );

Table created.

SQL>
SQL>
SQL> CREATE TABLE products(
  2    product_id                  NUMBER(6),
  3    product_name                VARCHAR2(50)
  4  );

Table created.

SQL>
SQL>
SQL> select c.cid, c.customer_state, s.sold, p.product_name
  2  from   sales s
  3    join emp c    on s.cid = c.cid
  4    join products p     on s.product_id = p.product_id
  5  where p.product_id = 117
  6  and c.country_id = 52790;

no rows selected

SQL>
SQL>
SQL> drop table sales;

Table dropped.

SQL> drop table emp;

Table dropped.

SQL> drop table products;

Table dropped.

SQL>
SQL>

   
    
    
  

Related examples in the same category