Thanks very much, exactly what I needed, I hadn't thought of
using brackets to control the join

>From: Carl van Tast <vanTast@...>

>SELECT *
> FROM b_matdet m
> LEFT JOIN (b_order o
> INNER JOIN b_order_ops oo
> ON o.b_o_ref = oo.b_o_ref)
> ON m.b_md_worder_ref = o.b_o_ref
> WHERE m.b_md_ref = 7023

_________________________________________________________________
Join the world�s largest e-mail service with MSN Hotmail.
http://www.hotmail.com