To address another database, you also need to include the owner: database.owner.tablename in mssql7, generally its db1.dbo.tablename
At 11:51 AM 1/31/2002 +0000, you wrote: >Dear all, > >I am using mySQL with CF 5. > >I wish to perform a join query which involves tables from two different >databases. I have tried the following syntax although it produces the error >"Table does not exist - db1.tablename". > >SELECT <fields> >FROM db1.tablename INNER JOIN db2.tablename >ON db1.tablename.column = db2.tablename.column >WHERE <condition> > >Can anyone give me any ideas? I know it isn't a mySQL permissions error >since the user has ALL permissions on both db's. I think the solution may >be in connection strings although I am unsure. Any assistance would be >appreciated. > >Regards, > >Martin. > ______________________________________________________________________ Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation � $99/Month � Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusiona FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/[email protected]/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
