Hi, is it in general possible (using mysql 4.1.10) in any way to get data from two datasources (combined in one query-tag)???
Asking google showed me some infos about ms sql (combining data from several sources.. http://www.databasejournal.com/features/mssql/article.php/3578546) Hmm... well.. I thought of just doing something simple like this.. select #strApp.localDsn#.tbl_products.fld_pid as pid from #strApp.localDsn#.tbl_products left join #strApp.RemoteDsn#.tbl_pdata on #strApp.RemoteDsn#.tbl_pdata.fld_pid=#strApp.localDsn#.tbl_products.pid where 1=1 But at first it (of course :) doesnt work, 2nd problem would be the dsnUser+Pass-args that can be set only once in the query-tag. (didn't look at queryparams yet) Anyway.. is that generally possibly? Is it possible with mysql? -- Sebastian Mork <[EMAIL PROTECTED]> ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:231507 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
