Parenthesis in Join Syntax for mdb files

[Guest]

Is there a way to create an Access database (i.e. programmatically via Jet or
another option) that allows a SQL Server like syntax for joins - specifically
without the nested parenthesis. And what exactly is the reason for the
parenthesis in Access? Is this conforming to some standard? What
interesting is that SQL Server 2000 and Oracle 9i also accept this
"parenthesis" syntax. Any information on this would be helpful. Thanks.

Access:
SELECT Customer.Name, OrderHeader.OrderNumber, OrderDetail.LineItem
FROM (Customer INNER JOIN OrderHeader ON Customer.ID =
OrderHeader.CustomerID) INNER JOIN OrderDetail ON OrderHeader.ID =
OrderDetail.OrderHeaderID;

SQL Server syntax (preferred):
SELECT Customer.Name, OrderHeader.OrderNumber, OrderDetail.LineItem
FROM Customer
INNER JOIN OrderHeader ON Customer.ID = OrderHeader.CustomerID
INNER JOIN OrderDetail ON OrderHeader.ID = OrderDetail.OrderHeaderID

 

[Guest]

Not AFAIK. I did some experiments previously selecting the ANSI 92 SQL but
JET still insists on the parentheses (at least through the QBE).

I actually prefer the parens as personally, I think it is easier to see how
the Tables are related.