My statement for the third to the last one: SELECT ORDER_NUM, ORDER_DATE FROM ORDERS, ORDER_LINE WHERE ORDERS.ORDER_NUM = ORDER_LINE.ORDER_NUM IN (SELECT PART_NUM FROM ORDER_LINE, PART WHER...
on the subquery, you want to select the ORDER_NUM, not the PART_NUM.
It's been a while. Here's what's new.
A complete history of our community — stats, Hall of Fame, legendary threads, and more.
All 225,969 pieces of content from 2000–2014 are here — forums, messages, journals, photos, polls, and events.
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.
