Cetin

Thanks, that was exactly what I needed (the dbo). Once I put that in, it all worked.

Kirk

SELECT     dbo.coAudit.ActionDT, dbo.coAudit.patientid, dbo.coAudit.deptid, dbo.coAudit.userid
FROM         dbo.coAudit INNER JOIN
                      ctoredev.dbo.users ON dbo.coAudit.userid = ctoredev.dbo.users.userid