How can i generate new query table from 2 database? just like vlookup function

How can i generate new query table from 2 database? just like vlookup function



I have 2 database file. I wants to create new query table & wants to append data from both database, which has one or two common field. so, is there specific function available? or is there requirement to write any specific query/programme just like vba macro?

 
If there any available specific example ? or how to create new query?
 
Can i get same data in zoho sheet or zoho creator on periodical interval?
 
Please help