<div>
thanx for the way<br />
<br />
it works with left join command<br />
i learned it<br />
<br />
MeCeX
</div>


thanx for the way

it works with left join command
i learned it

MeCeX

<div>
oh right cool, happy to help.
</div>


<div>
<div class="content wysiwyg-content">
Hi,<br />
<br />
I have 3 databases like below;<br />
<br />
DB1<br />
MUSID : autoinc<br />
...<br />
<br />
DB2<br />
TekID : autoinc<br />
MUSID : number<br />
...<br />
<br />
DB3:<br />
DB3ID : autoinc<br />
TekID: number<br />
Money : currency<br />
MoneyID : number<br />
<br />
I want to select the sum of money grouping by moneyid and MUSID. <br />
That is like<br />
MUSID &nbsp;MoneyID &nbsp;Sum of Money<br />
--------------------------<wbr />----------<wbr />-<br />
1 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;1 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;100<br />
1 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;2 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;150<br />
2 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;1 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;98<br />
...<br />
<br />
How can i do that with sql code ? I'm programming with delphi and none of the tables hav relationship between.<br />
<br />
Thanx..<br />
<br />
MeCeX
</div>
</div>


Hi,

I have 3 databases like below;

DB1
MUSID : autoinc
...

DB2
TekID : autoinc
MUSID : number
...

DB3:
DB3ID : autoinc
TekID: number
Money : currency
MoneyID : number

I want to select the sum of money grouping by moneyid and MUSID. 
That is like
MUSID  MoneyID  Sum of Money
-------------------------------------
1              1                100
1              2                150
2              1                98
...

How can i do that with sql code ? I'm programming with delphi and none of the tables hav relationship between.

Thanx..

MeCeX

SQL Query from diffrent tables - How to

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.