[ cf-dev ] Connecting to tables in different SQL Server databases.

[Osullivan Karl (RKB) Senior Analyst/Programmer]

Hi All I need to do a query that links tables across SQL Server databases that are on the same server. I'm unsure how to do this in CF, as when I set up a datasource it points to one database only.  Does anyone have any ideas how to do it please? Thanks Karl O'Sullivan Senior Analyst/Programmer Computer & Network Services UHCW NHS Trust Clifford Bridge Road COVENTRY CV2 2DX Contact: Tel (internal): 28952 Tel (external): +44 (0) 24 7696 8952 Email: [EMAIL PROTECTED] Web: www.uhcw.nhs.uk