title: Join data from two tables with autoincrement id from two databases
body: <p>I would like to join data from tables from two databases. One is filed with predefined values (itemId, itemName) and other is filled by user (itemId, itemName, userId). Atributes itemId and itemName are the same, from first table we select all data, from second we select data by userId and combine these two results. </p>
  
  <p>Joined data should be distinguish because ids are autoincrement and could be the same(doubled). We would like to fill drop down list with this data for example with datasource and dictionary (int is itemId, string is itemName)  we could only have valueFiled and valueText in dropDownList but ids of these two tables could be the same and lather we don`t know from wich table is item selected by id.</p>
  
  <p>Is there any elegant way to joint this, maybe with temp tables that we always when user is logged in join these two tables in temp table etc...</p>
  
  <p>Thank you for your answers</p>