Selecting from two database problem

Message Topic Search Topic Options Post Reply Create New Topic Printable Version Translate Topic

   I am attemting to select data from three tables, one of the tables lives in a different database on the same server. I have included an example of the select statement, but I think the issue revolves around the database.owner.object_name. It maybe to do with correct sytax but could not find any examples only to compare. 

I understand that data can be selected from other databases even though the strSQL opens only one database connection? 

Does anyone have any suggestions please?

Thanks in advance.

ulive.SB.admissions (ulive is database name, SB is username, admissions is table name) 

strSQL = "SELECT capd_person.p_forenames, capd_person.p_surname, capd_person.p_dob, apd_student.s_studentreference, capd_student.s_studentstatus, admissions.arrival_status " & _ 
"FROM capd_person INNER JOIN capd_student ON capd_person.p_id = capd_student.s_id LEFT JOIN ulive.SB.admissions ON capd_student.s_studentreference = admissions.stu_reference " & _ 
"WHERE admissions.arrival_status = '" & arrival_status & "' " 