> About parens in the FROM clause, I'm not clear what you are talking
> about. Could you give an example?

Well here is an example... ala MS Access

SELECT foobar
FROM LamMaker INNER JOIN (LamColor INNER JOIN (LamOrder INNER JOIN
OrderItem ON LamOrder.CustOrder = OrderItem.CustOrder) ON LamColor.ID
= OrderItem.Color) ON LamMaker.ID = LamColor.LamMaker

Hence, my wondering about the "weighting" of the joins... in this
case, doesn't it appear that LamOrder.CustOrder=OrderItem.Custorder
join is the *most* important - since it is in the inner-most parens???

I certainly hope not... as I can barely come to grips with the syntax
much less trying to figure out which join I want in the inner-most
parens!<groan!>

Thanks again for all the help - here and in the fb forum!!!

This "old dog" is certainly looking forward to your "new" book!

--Raymond