How to do a join in multiple datasets

I have two datasets accessed from two different data sources.
I would like to display the report by doing a join between the two. How can
I achieve that?
This join can not take place at data source level.Man that's a tough one.
I wonder if you could set the reports' data source to a custom assembly
which brings the two data sources together?
Alternatively, I suppose you could link the two datasources through another
database say Access if that's an option.
HTH
Matt
"Gaurav" <Gaurav@.discussions.microsoft.com> wrote in message
news:A729C0A5-ECC4-4337-B88F-0DF072FA2202@.microsoft.com...
> I have two datasets accessed from two different data sources.
> I would like to display the report by doing a join between the two. How
can
> I achieve that?
> This join can not take place at data source level.
>