Skip to main content
0 online
theremin Mar 19, 2004

Would the SQL statement for the first one look like: SELECT ORDER_NUM, ORDER_DATE, PART_NUM FROM ORDERS, ORDERS_LINE WHERE ORDERS.ORDER_NUM = ORDER_LINE.ORDER_NUM IN (SELECT PART_NUM, DESCRIP...

iwz iwz

looks like you've got the right idea. i might modify it like this tho:

SELECT ORDER_NUM, ORDER_DATE, PART_NUM
FROM ORDERS, ORDERS_LINE
WHERE ORDERS.ORDER_NUM = ORDER_LINE.ORDER_NUM AND
ORDER_LINE.ORDER_NUM IN
(SELECT PART_NUM, DESCRIPTION, CLASS
FROM PART, ORDER_LINE
WHERE PART.PART_NUM = ORDER_LINE.PART_NUM
ORDER BY CLASS, ORDER_NUM);

Welcome Back to eZabel

It's been a while. Here's what's new.

eZabel Lore

A complete history of our community — stats, Hall of Fame, legendary threads, and more.

View the Lore →

Everything Preserved

All 225,969 pieces of content from 2000–2014 are here — forums, messages, journals, photos, polls, and events.

💎

Gems

Spot something you love — a legendary comment, a classic thread, a great photo? Log in and click the diamond icon to mark it as a Gem. Add a note about why it's special. The best stuff surfaces on the Gems page.