Multiple Join To Different DB

[alex_read]

I'm using MS SQL Server 2000 here & the plan is to connect 2 tables from database1 to the same table in database 2 Um, can i have some help to pick apart the below statement so it'll work please????

SELECT Table1.Col1,  
	   Table2.Col1 
FROM   Table1  
INNER JOIN DB2.TableA AS TBL1 ON Table1.KeyCol = TBL1.KeyCol
INNER JOIN DB2.TableA AS TBL2 ON Table2.KeyCol = TBL2.KeyCol
WHERE Table1.KeyCol = 1