Scott Mulholland wrote: > In theory is there any downside to joining cross database.
In theory joining cross databases is not supported in the SQL standard. Therefore not every dbms will implement it, or they will require you to use clumsy workarounds. I find it hard to see the advantages when you can also use namespaces (schema's) for logical separation and tablespaces for physical separation (other diskdrive). Unless your database is *really* big, but then replication/clustering might be a better solution. Jochem ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net http://www.cfhosting.net Message: http://www.houseoffusion.com/lists.cfm/link=i:4:184963 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54