title: Cross table join using MYSQL rather than MSSQL
body: <p>Is it possible to do a cross table join in mysql spaning different tables? in different databases.</p>
  
  <p>This seem to be easily possible in MSSQL, and greatly speeds up data transfer?</p>
  
  <p>How about mysql, do you need to use a powerful IDE to achieve this? or do you have to write a program to do something like this?</p>
  
  <p>UPDATE tblUser 
  SET tblUser.ReceiveInfo=old_database.dbo.contact.third_party_info_yn
  FROM tblUser inner join old_database.dbo.contact 
  ON old_database.dbo.contact.id=tblUser.oldid</p>