Oracle SQL query GODS help wanted on this problem...

[Hawkeye-X]

Look at this:

select order_num, order_date from customer, orders, order_line
where customer.customer_num = orders.customer_num
and customer_name = 'Ferguson''s' and
orders.order_num = order_line.order_num
and order_line.part_num = part.part_num and
part.description = 'Gas Range';

I'm supposed to list the order number and order date for each
order that was placed by Ferguson's and that contains an order
for a Gas Range.

When I run this query, I get this error:

part.description = 'Gas Range'
     *
ERROR at line 6:
ORA-00904: invalid column name

Tell me what I'm doing wrong, so I don't look like a dufus.

Thanks!

Hawkeye-X

[jono]

1. You haven't included

the parts table in your FROM list.

:hi:

edit: i meant the part table, not parts.

[Hawkeye-X]

3. Oh damn.

That worked.

Thanks!

[TrogL]

9. are you sure

you wanted to display that column?

[DK666]

4. You were too fast...

Missed that one...

[monkeyboy]

2. Try double quotes

The problem is somewhere in quote-ville.

[Bozola]

5. Oracle is the spawn of Satan

aka Larry Ellison.

Ick

[DS1]

6. true, but once you master it, it's the Buddy Lee of DBMSs

Can't bust it!

[Meshuga]

7. Poor kitty!

in your signature. :-)

[Bozola]

8. I suggest you better catch up on those CERT advisories...

I hope you don't use 9i RAS....

(industry rumor is that they were more than a little pissed off)

http://computerworld.com/newsletter/0,4902,83186,00.html?nlid=DM


Orbitz: Oracle to blame for site outage
-----------------------------------------


The online travel company promptly dumped the 9i RAC database software

Story by Linda Rosencrance

JULY 17, 2003 ( COMPUTERWORLD ) - Orbitz LLC, the airline-owned travel Web site, suffered an outage yesterday related to an Oracle database on which Orbitz operates the site, according to a spokeswoman for the Chicago-based company.
Orbitz spokeswoman Carol Jouzaitis said it was the most severe outage to hit the online operation since the site launched approximately two years ago.

Declining to go into detail about what happened, Jouzaitis said the site went down early yesterday morning and was back up very early today. She stressed that no customer data was lost or corrupted as a result of the outage.

"It was an database issue, and we decided to make an architectural change to the site, a change that will put us in a position to move forward with even higher reliability," Jouzaitis said. "The site is performing great now."

Jouzaitis said that as a result, Orbitz is no longer using Oracle Corp.'s 9i Real Application Clusters (RAC) database software.

An Oracle spokeswoman in a statement this afternoon stressed that no customer data was compromised by the outage.

"As with all Oracle customers, we worked closely together with our partners and Orbitz to resolve the issue as quickly as possible," she said. "No Orbitz customer data has been lost or corrupted as a result of the situation yesterday, and the site is again operational."

The Orbitz outage comes at a time when Oracle is touting its "unbreakable" software in an extensive marketing campaign. "Unbreakable" refers to a database that will not go down, even if the server or the site fails. Oracle is also in the midst of a hostile takeover of rival PeopleSoft and is trying to project a customer-friendly image.