Re: Information on joins.

From: <tandym_at_hotmail.com>
Date: Wed, 08 Mar 2000 19:57:36 GMT
Message-ID: <8a6bbd$2q4$1@nnrp1.deja.com>

It looks as though you misspelled the word 'COMPANY' in the Company table for your Software Company entry.

sonya

In article <xuxx4.647$Q27.18152_at_news.uswest.net>, "Conrad" <csmith15_at_uswest.net> wrote:
> 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?
>
>

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Wed Mar 08 2000 - 13:57:36 CST