In Access 2010, how do I create a SQL query?

E

ew68

In older versions of Access, there was a View -> SQL View menu button. How
do I get the SQL View with Access 2010? I need to create a query which
contains a join operation. I don't think I can do this with the Query Design
view.
 
A

Antoine Yassa

I searched for the same issues. I discovered accidentally that by setting the cursor in the Design View of the preliminary Query, the Contextual menu (Right Click) offers the choice of SQL View that was much more easy to access in earlier versions of MS Access
 
Top