There are two schemas D1
and D2
which have the same table with different data called Hotels
.
I need to get the data list of under 'Vista'
name
, ID
,P-Email
, D-Email
, X-Email
and Z-Email
from those two tables. Primary Key is ID
. What is the query for this?
Nimasha Jayathunga :
USE D1;\nSelect ID, P-Email, D-Email, X-Email, Z-Email from Hotels where Name ='Vista';\n\nUSE D2;\nSelect ID, P-Email, D-Email, X-Email, Z-Email from Hotels where Name ='Vista';",
2020-02-23T17:24:15