Sintak Dasar
Dibawah ini ialah sintak dasar Cross Join atau Cartesian Product pada Oracle SQL:SELECT table1.column1, table2.column2... FROM table1, table2 [, table3 ]
Contoh
Asumsikan Anda telah memiliki dua tabel, yaitu tabel Customer dan tabel Orders dengan data-data sebagai berikut:Tabel Customer
SQL> SELECT * FROM customer; CUSTOMER_ID CUSTOMER_NAME CUSTOMER_ADDRESS ----------- ----------------- ----------------- CS001 Nursalim Bandung CS002 Nani Indriyani Jakarta CS003 Naura Krasiva Surabaya CS004 Ahmad Fatoni Semarang CS005 Sri Rahayu Yogyakarta
Tabel Orders
SQL> SELECT * FROM orders; ORDER_ID ORDER_DATE CUSTOMER_ID QTY AMOUNT -------- ---------- ----------- ----- ------- 00001 01-04-2015 CS001 2 10000 00002 08-04-2015 CS001 3 7000 00003 14-04-2015 CS004 1 15000
Untuk memakai Cross Join pada kedua tabel diatas, Anda sanggup memakai query SQL di bawah ini:
SQL> SELECT customer.customer_id, customer.customer_name, orders.order_id, orders.order_date, orders.qty, orders.amount 2 FROM customer, orders; CUSTOMER_ID CUSTOMER_NAME ORDER_ID ORDER_DATE QTY AMOUNT ----------- ------------------ -------- ---------- ----- ---------- CS001 Nursalim 00001 01-04-2015 2 10000 CS002 Nani Indriyani 00001 01-04-2015 2 10000 CS003 Naura Krasiva 00001 01-04-2015 2 10000 CS004 Ahmad Fatoni 00001 01-04-2015 2 10000 CS005 Sri Rahayu 00001 01-04-2015 2 10000 CS001 Nursalim 00002 08-04-2015 3 7000 CS002 Nani Indriyani 00002 08-04-2015 3 7000 CS003 Naura Krasiva 00002 08-04-2015 3 7000 CS004 Ahmad Fatoni 00002 08-04-2015 3 7000 CS005 Sri Rahayu 00002 08-04-2015 3 7000 CS001 Nursalim 00003 14-04-2015 1 15000 CS002 Nani Indriyani 00003 14-04-2015 1 15000 CS003 Naura Krasiva 00003 14-04-2015 1 15000 CS004 Ahmad Fatoni 00003 14-04-2015 1 15000 CS005 Sri Rahayu 00003 14-04-2015 1 15000 15 rows selected.
