Q: reporting from two different database

I have two different databases DB1 and BD2. which one table in each.
TableDB1: ID, Amount1 and TableDB2: ID, Amount2.
Now my sub-report in Reporting Services should report ID and sum of
DB1.TableDB1.Amount1 and
DB2.TableDB2.Amount2. How should I
write my query?select t1.ID, t1.Amount+t2.Amount
from Db1.Table1 t1 join Db2.Table2 t2 on t1.ID=t2.ID should work
Sam
"JIM.H." wrote:
> I have two different databases DB1 and BD2. which one table in each.
> TableDB1: ID, Amount1 and TableDB2: ID, Amount2.
> Now my sub-report in Reporting Services should report ID and sum of
> DB1.TableDB1.Amount1 and
> DB2.TableDB2.Amount2. How should I
> write my query?
>