Select from

[jpillonel]

Hello,

I need to select tables accross two database how can I do that ?

For this statement:

use directory
select DISTINCT account from fileindex
where pathid in (select nameid from pathnames where name like 'C:\Data\%')

I need to add another table from a anoter database, how can I do that ?

I run MS SQL 2000


thanks for your help !!

 

[PHV]

I run MS SQL 2000
You may have more accurate replies in a Microsoft SQL Server forum.

Hope This Help, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884