<div>
Can you please give an example?
</div>


<div>
you have to provide the sample set. the sample data in your 7 tables and the expected result.
</div>


you have to provide the sample set. the sample data in your 7 tables and the expected result.

<div>
<div class="content wysiwyg-content">
I am in need of some help. &nbsp;I am trying to get 7 tables to work together so that I can do a summary of all the data in these tables. &nbsp;All of the data is basically the same except I need to add the information together to create a quartly report. &nbsp;The report has to be in Excel but all the data resides in Microsoft Access. &nbsp;Does anybody have a clue as to how I can do this? &nbsp;Please let me know. &nbsp;Thanks!
</div>
</div>


I am in need of some help.  I am trying to get 7 tables to work together so that I can do a summary of all the data in these tables.  All of the data is basically the same except I need to add the information together to create a quartly report.  The report has to be in Excel but all the data resides in Microsoft Access.  Does anybody have a clue as to how I can do this?  Please let me know.  Thanks!

Joining tables and records so everything comes together

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.