hello, What the best way to to join 2 tables accross 2 databases ?
actually i do on the 1rt database a select First 100 ID from myTable1 where ... and in the seconde database select * from MyTable2 where ID in (<id_we_retrieve_from_the_first_select>) but the problem, the select * from MyTable2 where ID in (<id_we_retrieve_from_the_first_select>) is very slow, especially on the prepare :( is their any better way ?
