Sign In| Join
Get Help:Ask a Question in our Forums|Report a Bug|More Help Resources
Participant
875 Points
301 Posts
Mar 01, 2012 04:16 AM|LINK
Hi,
Try like this,
Declare @sql Varchar(500)
SET @sql='select a.id,b.id from databaseA.'+@table_name+' a inner join databaseB.'+@table_name+' b on a.name=b.name'
EXEC (@sql)
vendan
Participant
875 Points
301 Posts
Re: join different database to get table sp (sql server)
Mar 01, 2012 04:16 AM|LINK
Hi,
Try like this,
Declare @sql Varchar(500)
SET @sql='select a.id,b.id from databaseA.'+@table_name+' a inner join databaseB.'+@table_name+' b on a.name=b.name'
EXEC (@sql)
Kalaivendan
Please Mark as Answer if this post helps you!