Re: Information on joins.

    Here is the join that I am trying to join:

SQL> SELECT * FROM BILLS;

NAME                                        AMOUNT ACCOUNT_ID
---------------------------------------- --------- ----------
PHONE COMPANY                                  125          1
POWER COMPANY                                   75           1
RECORD CLUB                                           25           2
SOFTWARE COMPANY                           250          1
CABLE TV COMPANY                               35           3
JOES CAR PALACE                                   350          5
SC STUDENT LOAD                                  200          6
FLORIDA WATER COMPANY                   20          1
U-OF-U INSURANCE COMPANY           125          5
DEBTORS CREDIT CARD                           35          4

10 rows selected.

SQL> SELECT * FROM COMPANY
  2 ;

NAME                                        ADDRESS
CITY                          ST

------------------------------ ---------------------------------------------
-- ------------------
PHONE COMPANY                  111 1ST STREET        ATLANTA
GA
POWER COMPANY                  222 2ND STREET       JACKSONVILLE
FL
RECORD CLUB                          333 3RD AVENUE     LOS ANGELES
CA
SOFTWARE COMAPNY           444 4TH DRIVE         SAN FRANCISCO
CA
CABLE TV COMPANY              555 5TH DRIVE        AUSTIN

    This is my join and it's accompanying error:

SQL> SELECT COMPANY.NAME, CITY.NAME, BILLS.AMOUNT, BILLS.ACCOUNT_ID   2 FROM BILLS,COMPANY
  3 JOIN BILLS ON BILLS.AMOUNT = 250
JOIN BILLS ON BILLS.AMOUNT = 250
     *
ERROR at line 3:
ORA-00933: SQL command not properly ended

    What is it that I am doing incorrectly?     Thank you for your help. Received on Tue Mar 07 2000 - 12:13:10 CST