In Search Of Opinions About My Select Statement

[Diana Magers]

SELECT ORDER_NUM, ORDER_DATE

FROM ORDERS, CUSTOMER

WHERE CUSTOMER.CUSTOMER_NAME = 'Johnson Department Store'

UNION

SELECT ORDER_LINE.ORDER_NUM, ORDERS.ORDER_DATE

FROM ORDERS, ORDER_LINE

WHERE ORDER_LINE.PART_NUM = 'DR93';

looking for order_num and order_date for each order that was placed by Johnson Department Store that also contains an order_line for a Gas Range (GAS RANGE PART_NUM IS 'DR93'.

Up above is what I have so far.

TABLES INCLUDED:

ORDERS ~

ORDER_NUM, ORDER_DATE, CUSTOMER_NUM

ORDER_LINE ~

ORDER_NUM, PART_NUM, NUM_ORDERED, QUOTED_PRICE

PART ~

PART_NUM, DESCRIPTION, ON_HAND, CLASS, WAREHOUSE, PRICE

CUSTOMER ~

CUSTOMER_NUM, CUSTOMER_NAME, STREET, CITY, STATE, ZIP, BALANCE, CREDIT_LIMIT, REP_NUM

ONLY LOOKING FOR DIRECTION NOT LOOKING FOR SOMEONE TO GIVE ME THE ANSWER. I NEED TO ANSWER ON MY OWN.

[Author]

Posts