I have a database that has all personnel records. I have another database that has records that relate to those personnel and in access I would add links to the databases and then use a sql join to select the data.

In VS2005, how do I accomplish the same thing? If I drop a sqldataadapter on the formm, it can only connect to one database. Do I need to populate a dataset with one table from one database and then then do the same from the other database and then do some database relations and then access the dataset? IF so, does anyone have any examples of such a monster?