Mega Code Archive
Two join on clauses
<![CDATA[
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>
]]>