I have two different databases, and want to take data from both databases and insert it into a gridview.

Here is my problem:

DB1 has two tables from which I need to pull data

**User**   

FName  

LName  

Email  

*UserId*  

*UserName*

**UserData**  

Role  

Department  

*UserId*

DB 2 has 1 table from which i need to pull data

**Login**  

CreateDate  

*UserName*

My gridview ultimately needs to display the following:

fName lName Email Department Role CreateDate

I somehow need to connect these three tables into 1 gridview. I do not have control over the database, so I cannot create any new tables. My problem is that I cannot seem to link these successfully. Any ideas on how to go about tackling this?