Query wizard

  • Thread starter Thread starter croy
  • Start date Start date
C

croy

Guest
I have a query that i want to turn into Outer/inner join, instaed of Ansi.
how can Access do that for me?
 
I'm not sure that I understand the question. When you build a query using the design view in Access, you select a field in one table and drag it to a field in another table to specify a join. The default join type is Inner. To change the join type to Left or Right outer, right click on the center of the join line to bring up the join type dialog box. If the properties box comes up instead, close it and try clicking again. You need to be pointing to the center of the line to get the correct dialog box up.
 

Users who are viewing this thread

Back
Top Bottom