I want to implement SELECT, UPDATE and DELETE SQL statement that access data from multiple dateases. This datebases may be in the same server or remote locations.
1)customer table may be in one location and product table in another loaction. I want to create a SQL that is
SELECT custmer_name, phone_no
FROM Customer, Product
WHERE order_id = product_id and product_nm="DUNLOP TIRE"
2)Need to update table Patient_info thats reside in two different locations server in different databases.
3) Should I be able to implement join queries in multiple databease?
If someone can help me out that would be great. Thanks in advance.