Join tables from different Db's

Hi,
I want to use a table from one db and do an inner join on a table which is
present in the other Db. Is it possible to do this in reporting Services? And
if yes, then how?
Thanks
--
pmuddoes a query like this doesn't works?:
select * from tableA inner join DatabaseB.dbo.TableB on ....
"pmud" <pmud@.discussions.microsoft.com> wrote in message
news:CE7B6ED2-9668-4B3D-BB9A-A40D3C422C57@.microsoft.com...
> Hi,
> I want to use a table from one db and do an inner join on a table which is
> present in the other Db. Is it possible to do this in reporting Services?
> And
> if yes, then how?
> Thanks
> --
> pmud