I want to perform a table joing across two different databases stores on the same SQL server.<BR><BR>I have one database called DB1 with a table of People and another Databse called DB2 with a table of LoginDetails. I want to be able to join the DB1.People and DB2.LoginDetails together for queries. Eg....<BR><BR>Dim DB1, DB1Str, strSQL, DB1RS<BR>Set DB1 = Server.CreateObject("ADODB.Connection") <BR>DB1Str = "DRIVER={SQL Server};SERVER=;uid=xxx;password=xxx"< BR>DB1.Open DB1Str<BR>strSQL = "SELECT * FROM LoginDetails INNER JOIN People ON LoginDetails.Per_ID = People.Per_ID WHERE (People.EmailAddress = &#039;" & strEmail & "&#039; AND LoginDetails.Password = &#039;" & strPassword & "&#039;)"<BR>Set DB1RS = DB1.Execute (strSQL)<BR><BR>Presently I get an "Invalid object name &#039;People&#039;" when running the ASP.<BR><BR>I&#039;m really stuck on this one and would appreciate any pointers and work-arounds.<BR><BR>Cheers,<BR>Jason &#060;mailto:jallen@pobox.com&#062;