Hello!!

I have one db (NUKE) and another db(web) -- 2 DB's

So!

In the WEB database i have a tbl called customers with a field named Id

In the nuke database i have the users table with the same id field

I make a query to Obtain the customer's name and the reports retrieve an error.... I must declare the variable @ID ... i made it, but it give always the same error.

At the end, what i want is only a simple query like:

SELECT W.Name, W.Adress FROM web.Customers w INNER JOIN NUKE.Users U ON W.Id=U.Id

Hi Mitchel !!

Yes

The DB's are in the same server...

Ok. it works fine, not with the reports module, but with myselve module of reports with a conectionstring to the other bd .... Solved

But now i need to query the db like that

SELECT W.Name, W.Adress
FROM web.Customers w
    INNER JOIN NUKE.dbo.Users U
 ON W.Id=U.Id

WHERE U.ID=(User logged)

You could help me with that ?