>If you want to include orders placed with a parent company you'll need an
>outer join, something like
>
>SELECT o.orderID, c.clientname, p.clientname
>FROM ((order o LEFT JOIN client c ON o.clientID = c.clientID) LEFT JOIN
>client p ON c.parentID = p.clientID)
That worked perfectly - thanks a lot! I guess I should learn joins a little
better and rely less on subqueries :)
K.
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
