Cross-database queries?

[csn]

I just heard that mysql supports "cross-database queries." Um, okay...why would anybody even want to do such a thing?

Postgresql doesn't have this, does it?

[khendar]

example: You have several sites which track traffic stats via their own database and wanted to combine them into a single database for server-wide reporting.

[Frederick]

What do you mean by cross-database queries? Like querying a MS Access DB and a MySQL DB.

[Frederick]

If it is what khendar is saying. I am doing a project soon combining an existing SQL DB with a new app using MySQL and outputting for production purposes. This way production does not cause conflict during order entry and so on.

[bpat1434]

Cross database queries are those when you query more than one database at a time. I'm not sure of exactly how to do it, but I do know mySQL supports it. In short:
It's querying multiple databases at one time to get information.

Multiple databases of the same type, mySQL, Postgre and what not. Not cross platform database queries.... they're not possible. Unless you're using SQL standard queries.