how to count of two table from differen database in asp.net

You can use like SELECT a.userID, b.usersFirstName, b.usersLastName FROM databaseA.dbo.TableA a inner join databaseB.dbo.TableB b ON a.userID=b.userID