Link tables in database software other than access?

[dtharpe1]

The program i work for uses Access databases for our production site now and we are having alot of database corruption it seems. I was brought in to build a brand new site but decided to make the move to MySQL database but i noticed that link tbales feature that access currently has where you can link two table from diffrent access databases on the same server is not present in MySQL. This was a great feature in that it enabled you to only specify one datasource in <cfquery> when your actually using three. My question is that is there any other database software that supports this feature?

Thanks,

D

[Dan_Bracuk]

Oracle and sql server support it.  Mysql might even support it.  The gist of it is that you establish your permissions at the database server level, and in your query you use the database name to qualify the tablename when required.  Something like this

select something

from table1 t1 join otherdatabase.table2 t2 on t1.something = t2.something

etc

[dtharpe1]

Hey thanks for the reply,

     But what im saying is that  when you specify a datasource in a cfquery you can only specify one. Can you please give me a working example of what your are saying (syntactically correct). That would be great because I have been searching for this answer for the last week. And also thanks for letting me know which databases do support it, i have been trying in MySQL for like three days and it doesnt work.

Thanks for all your help,

D

[Dan_Bracuk]

for the mysql part, mgoogle "mysql select different database".  For the cfquery part, you will need only one datasource.