Re: Information on joins.

"Conrad" <csmith15_at_uswest.net> wrote in message news:xuxx4.647$Q27.18152_at_news.uswest.net...
> I entered you recommendation and here was the result:
>
> SQL> SELECT COMPANY.NAME,COMPANY.ADDRESS,BILLS.AMOUNT,BILLS.ACCOUNT_ID
> 2 FROM BILLS,COMPANY
> 3 WHERE BILLS.NAME=COMPANY.NAME
> 4 AND BILLS.AMOUNT=250;
>
> no rows selected
>
> The problem is this:
>
>
> 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.
>
> On line four amount=250. Any ideas?

and what is the result of
SELECT * FROM COMPANY ; ??? --
WBR, Denis Golikov aka NoMad Frog
Don`t FAQ with me ! ;-) Received on Thu Mar 09 2000 - 04:13:07 CST