Retrieve Data from Multiple Tables

SPOOL RETRIEVE_TWO

SELECT * FROM CUSTOMER S, CHECKING H WHERE S.ACCOUNT_NUMBER=H.ACCOUNT_NUMBER;

SELECT FIRST_NAME, MIDDLE_INT, LAST_NAME FROM CUSTOMER S, CHECKING H WHERE S.ACCOUNT_NUMBER=H.ACCOUNT_NUMBER;

SELECT FIRST_NAME, MIDDLE_INT, LAST_NAME FROM CUSTOMER S, CHECKING H WHERE S.ACCOUNT_NUMBER=H.ACCOUNT_NUMBER AND LAST_NAME='SMITH';

SELECT LAST_NAME, CHECKING_TOTAL FROM CUSTOMER S, CHECKING H WHERE S.ACCOUNT_NUMBER>5555555555;

SELECT FIRST_NAME, MIDDLE_INT, LAST_NAME FROM CUSTOMER S, CHECKING H, SAVING V WHERE S.ACCOUNT_NUMBER=H.ACCOUNT_NUMBER AND S.ACCOUNT_NUMBER=V.ACCOUNT_NUMBER;

SELECT FIRST_NAME, MIDDLE_INT, LAST_NAME FROM CUSTOMER S, CHECKING H, SAVING V WHERE S.ACCOUNT_NUMBER=H.ACCOUNT_NUMBER AND S.ACCOUNT_NUMBER=V.ACCOUNT_NUMBER ORDER BY LAST_NAME;

SPOOL OFF

Home