• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 696
  • Last Modified:

Access Left Outer Join - Design View

I have Tables A and B. I want to only keep in Table C, the records from Table A that are not at all in Table B. In a Venn diagram, this would be the left most half moon of Table A. The entire circle of Table B would not be in Table C.

Is there a manner to create this in Query Design view, without using SQL code? All join options in Design View include at least partial inclusion of records from Table B.

Thanks.
0
tahirih
Asked:
tahirih
  • 2
  • 2
2 Solutions
 
Patrick MatthewsCommented:
You can do this wholly in design view.

1) Add TableA and TableB

2) Use drag and drop to change the INNER JOIN to LEFT JOIN/RIGHT JOIN by double clicking the
"link line" between TableA and TableB and editing the join options

3) Add at least one column from TableB to the query, uncheck the "display" checkbox, and enter Is Null in
the criteria for that column
0
 
tahirihAuthor Commented:
Let me also add tht this is a modified Left Outer Join, since I am extracting out records from Table A that are in Table B.

Thanks.
0
 
Patrick MatthewsCommented:
tahirih,

Yes, and I crafted the instructions above with that in mind.

Perhaps it would be easier if you entered a query like this in SQL view, then switched to design view to see
what Access does with it:

SELECT a.*
FROM TableA a LEFT JOIN
      TableB b ON a.ID = b.ID
WHERE b.ID Is Null

Regards,

Patrick
0
 
tahirihAuthor Commented:
Thanks.
0

Featured Post

Visualize your virtual and backup environments

Create well-organized and polished visualizations of your virtual and backup environments when planning VMware vSphere, Microsoft Hyper-V or Veeam deployments. It helps you to gain better visibility and valuable business insights.

  • 2
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now