I'm using sql 2000 and I not known some stuff about sql 2005, one of that are if it´s possible using mdf/file connection strings on sql 2005 if I can open two files and make only 1 t-sql statment with a inner join.



something like

DB1.MDF (Customers)

DB2.MDF (products)



and make something like:

select * from [db1.dbo.customers] C inner join [db2.dbo.products] on...... where...



It´s a crazy question but only I want to known if it´s posible :/



thanks