In the following SQL Join I am trying to get the same result as if I had created a view that joined the Orders and Customers table and then joined that view to the Shippers table. I am using brackets around the first join. Is this the right way to go about this?
(Orders Left Join Customers On (Orders.[Customer ID] = Customers.ID)) Left Join Shippers On (Orders.[Shipper Id] = Shippers.ID)