흠....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;

::

::