The query to calculate the total order amount per customer is: The account issuing the query must have sufficient privileges on the tables in both databases to execute the query.customers.customer instead of just customer). You must prefix all table references with the database name (e.g.It is possible to use SQL to write one query that combines the information from many databases. For example, you can have a MySQL server installation on machine X that hosts both the customers and orders database. The easiest case is when all of the databases are on a single server instance. Multiple Databases on One Server Instance
0 Comments
Leave a Reply. |