SQL concardination of two databases

[Ulrik48]

How do I concardinate two databases i the same select statement -

I have a database containing all employees
and another one containing selected products

now i want to see all employees, and their choices, I have a key field in both, LoginID - buth physically its two bases - Ulrik

[EXreaction]

Do you have two databases or just two database tables in the same database?

Between two tables is easy. I've never done a select between multiple databases, but I think I know of a way to do it as long as they are both on the same SQL server and are accessible by the same user account you've logged in with.

[EXreaction]

Yep, I've tested it out and you can do a selection between multiple databases as long as it is on the same SQL server and the same user account has access to both.

You could do something like:

SELECT e.*, p.*
FROM employee_database_name.employee_table_name e, product_database_name.product_table_name p
WHERE e.LoginID = p.LoginID;