|Subject||Re: TIBOQuery - editing contents from grid|
> About parens in the FROM clause, I'm not clear what you are talkingWell here is an example... ala MS Access
> about. Could you give an example?
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
Thanks again for all the help - here and in the fb forum!!!
This "old dog" is certainly looking forward to your "new" book!