Re: Information on joins.

    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? Received on Wed Mar 08 2000 - 13:02:47 CST