<div>
I would appreciate detailed table structure.<br />

</div>


I would appreciate detailed table structure.


<div>
If it has the same structure, use INNER JOIN<br />

</div>


If it has the same structure, use INNER JOIN


<div>
bhummel,<br />
Hi,<br />
<br />
E-mail me the database even with 2 records and I'll send you the code.<br />
<br />
shay@hili.com<br />
<br />

</div>


bhummel,
Hi,

E-mail me the database even with 2 records and I'll send you the code.

shay@hili.com



<div>
richtstieg,<br />
I used your code and it combined the rows. Thanks for your help.<br />
<br />
Brad<br />

</div>


richtstieg,
I used your code and it combined the rows. Thanks for your help.

Brad


<div>
<div class="content wysiwyg-content">
Greetings,<br />
I have created an SP which summarizes finacial statement information. I have created three temp tables(one with Revenue, one with Expenses, one with Excluded items).<br />
<br />
I now want to: Merge these three temp tables into one so I can have one record with expenses, revenue and excluded items. The keys which are common for all temp tables are pool number, loan number and statement date.<br />
<br />
How do I join these three tables.<br />
<br />
Thank you for your help...<br />
Brad
</div>
</div>


Greetings,
I have created an SP which summarizes finacial statement information. I have created three temp tables(one with Revenue, one with Expenses, one with Excluded items).

I now want to: Merge these three temp tables into one so I can have one record with expenses, revenue and excluded items. The keys which are common for all temp tables are pool number, loan number and statement date.

How do I join these three tables.

Thank you for your help...
Brad

Newbie SQL Question

Visual Basic is Microsoft’s event-driven programming language and integrated development environment (IDE) for its Component Object Model (COM) programming model. It is relatively easy to learn and use because of its graphical development features and BASIC heritage. It has been replaced with VB.NET, and is very similar to VBA (Visual Basic for Applications), the programming language for the Microsoft Office product line.