흠....outer join 이 뭐하는 거고..
어떻게 쓰는 건가요..?
>>이승현 님께서 쓰시길<<
:: SELECT name, order_id
:: FROM customer, salesorder
:: WHERE customer.customer_id = salesorder.customer_id
:: UNION ALL
:: SELECT name, NULL
:: FROM customer
:: WHERE customer.customer_id NOT IN (SELECT customer_id FROM salesorder)
::
:: ORDER BY name;
::
::
|