of the database. It is possible when those table having relations in between. Using join statement we can select data form the multiple table with the single query
. It means we can say that joins are used to combine rows from two or more tables.
(b) Another table is ORDERS as follows:
SQL> SELECT ID, NAME, AGE, AMOUNT
FROM CUSTOMERS, ORDERS
WHERE CUSTOMERS.ID = ORDERS.CUSTOMER_ID;
This would produce the following result:
SQL> SELECT ID, NAME, AGE, AMOUNT
FROM CUSTOMERS, ORDERS
WHERE CUSTOMERS.ID = ORDERS.CUSTOMER_ID;