<div>
In case if it complains, you can enclose the JOIN in parentheses.<br />

<pre><code class="code-1 nolinks" id="code-20-41738149-1"><span>SELECT * </span>
<span>FROM   (table1 </span>
<span>        INNER JOIN table2 </span>
<span>                ON table1.field1 = table2.field2 </span>
<span>                   AND table1.field2 = table2.field2 </span>
<span>                   AND table1.field3 = table2. field3) </span>
</code></pre>
</div>


<div>
Paul is on the right track. &nbsp;If you want exact matches on all three fields, use his first example. &nbsp;No WHERE clause is necessary. &nbsp;If you want to get partial matches, then use a cross join &nbsp;with OR as the relational operator for the WHERE clause. &nbsp;But in the case where you are using the &quot;OR&quot;, you will need to select the relevant columns from BOTH tables.<br />
<br />
Select table1.*, table2.* <br />
from table1, table2<br />
where table1.name= table2.name<br />
OR table1.phone=table2.phone<br />
OR table1.address=table2.addr<wbr />ess
</div>


<div>
Thanks folks! So if in the results I get for this query, if I delete records, it only deletes from table1 since I am only pulling FROM table1, correct?
</div>


<div>
The query worked great, I managed to query all the records I wanted to query. I tried deleting them from table1 as that is my ultimate goal, but Access wouldn't allow that. I worked around it via using the unique IDs of these records, created a new table with these results, and just deleted from table1 using referencing this table. Is there an easy way to perform a delete function using this same query though?
</div>


<div>
Oh I used Paul's query, and thanks for the info Pat!
</div>


<div>
Paul had a typo in his query, but I believe his intentions should be clear. He had said table2.field2 at the start of the join when it should be table2.field1
</div>


<div>
<i>inner join table2 on &nbsp;table1.field1 = table2.field2</i><br />
<br />
mea culpa that was an error, it should have been<br />
<br />
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; inner join table2 on &nbsp;table1.field1 = table2.<b>field1</b><br />
<br />
(in my defense I was answering using a phone bouncing about in a train :-)<br />
<br />
Thanks.
</div>


<div>
Wow thanks Paul! I think EE should get that train moment on video and pay you for an advertisement emphasizing troubleshooting from anywhere :p
</div>


<div>
<div class="content wysiwyg-content">
hello!<br />
I have two tables in Access 2010 let's say table1 and table2. Both tables have field 1, field 2, and field 3 that are common fields. I want to query all the records in table 1 where field 1, field 2, and field 3 exist in table2. So basically something like <br />
<br />
Select * from table1 where table1.field1 = table2.field2 and table1.field2 = table2.field2 and table1.field3 = table2. field3<br />
<br />
let's say I want to find all the records in table 1 where name, phone, and address all exist in table 2. I just don't know how to write that exactly. Thanks!
</div>
</div>


hello!
I have two tables in Access 2010 let's say table1 and table2. Both tables have field 1, field 2, and field 3 that are common fields. I want to query all the records in table 1 where field 1, field 2, and field 3 exist in table2. So basically something like 

Select * from table1 where table1.field1 = table2.field2 and table1.field2 = table2.field2 and table1.field3 = table2. field3

let's say I want to find all the records in table 1 where name, phone, and address all exist in table 2. I just don't know how to write that exactly. Thanks!

writing SQL in Access 2010

Microsoft Access is a rapid application development (RAD) relational database tool. Access can be used for both desktop and web-based applications, and uses VBA (Visual Basic for Applications) as its coding language.