PRB: Query Designer Creates Wrong SQL Statement on MDB Files

MORE INFORMATION

This section demonstrates how to reproduce the behavior. To do this, you need to know how to use the Query Designer. In this example, you will create a connection to the NorthWind Access database (NWIND.MDB).

Steps to Reproduce Behavior

1. Drag the Order Details and Products table into the Query Designer Window. The tables appear in the Diagram Pane with join lines.
2. Click ProductName in the Products table and Quantity in the Order Details table.
3. Right-click the join line and click Select all Rows from Order Details. The following SQL statement appears in the SQL pane:

         SELECT
         FROM { oj `Order Details` LEFT OUTER JOIN
         Products ON `Order Details`.ProductID = Products.ProductID }
   						

RESULT: The SQL statement contains brackets and the ODBC OJ syntax.

Following is the correct SQL statement.

      SELECT
      FROM `Order Details` LEFT OUTER JOIN
      Products ON `Order Details`.ProductID = Products.ProductID