Re: Information on joins.

Conrad wrote:
>
> 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
> TX
>
> 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.

delete line 3 and use:

	WHERE BILLS.NAME = COMPANY.NAME
	AND  BILLS.AMOUNT = 250

--
Jerry Gitomer
Once I learned how to spell DBA, I became one. Received on Tue Mar 07 2000 - 22:54:35 CST