title: create view across different databases?
body: <p>If I have database test1 and database test2, and table employee1 under database test1 and table employee2 under database test2, is it possible to create a view of employee2 under database test1 in MySQL. If so, can you show me the syntax.</p>
  
  <p>Both the databases are in the same machine.</p>
  
  <p>Thanks in Advance</p>