Combining 3 tables

[Guest_imported]

<br>I need help on how to combine 3 tables where 2 tables have similar fields . I am trying to use subqueries. <br><br>select...... from table 1, table 2, table 3 where X in (select....and where X in (select...)) <br>Anyone has any suggestions?

 

[MikeLacey]

Hi Cheri,<br><br>I'm sure we can figure something out. &lt;grin&gt; Could you post a bit more detail? <p>Mike<br><a href=mailto:michael.j.lacey@ntlworld.com>michael.j.lacey@ntlworld.com</a><br><a href=

http://www.cargill.com/>

Cargill's Corporate Web Site</a><br>

 

[TheInsider]

Need a little more detail on what you are trying to do, but you may want to look into using a Union Query.<br>Rob Marriott