<div>
Cool. &nbsp;I don't get the WHERE clause, however. &nbsp;1 does not equal 2. &nbsp;How does this work.
</div>


Cool.  I don't get the WHERE clause, however.  1 does not equal 2.  How does this work.

<div>
with &nbsp;the where condition that can not be true, you will not get any records returned. so, what you will get is just the structure of the tables..<br />

</div>


with  the where condition that can not be true, you will not get any records returned. so, what you will get is just the structure of the tables..


<div>
<div class="content wysiwyg-content">
Experts,<br />
<br />
I have Table A with fields 1,2,3,4 and Table B with 5,6,7,8. &nbsp;I want to merge just the STRUCTURE of the tables so I'll have Table AB with fiels 1,2,3,4,5,6,7,8. &nbsp;Is there an automatic way to do this (code, not manual)?<br />

</div>
</div>


Experts,

I have Table A with fields 1,2,3,4 and Table B with 5,6,7,8.  I want to merge just the STRUCTURE of the tables so I'll have Table AB with fiels 1,2,3,4,5,6,7,8.  Is there an automatic way to do this (code, not manual)?


Merging Table Structures

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.

Microsoft Access

SQL (Structured Query Language) is designed to be used in conjunction with relational database products as of a means of working with sets of data. SQL consists of data definition, data manipulation, and procedural elements. Its scope includes data insert, query, update and delete, schema creation and modification, and data access control.