> That worked, thanks. It just got a little more complicated though -
> I'm getting orders from the branches (ie with a parentID that's NOT
> 0) but not those orders placed directly by a parent company (ie, with
> a parentID of 0).
The syntax error is probably from *=
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)
Nick
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
