Hi
I am working in sqlserver and use Join. i have two table and the field is id, name , salary. I want to the id in first table and in second table name. please define exact query with join.
Loading
Know the answer? Post it — somebody with the same question will find it here.
Sign in to answer this question
It is the same account you read, post and publish with — and you will come straight back to this page.
Santhosh Kumar JayaramanPosted Jul 20, 2012, 9:16 AM
Rahul BhattPosted Jul 20, 2012, 9:06 AM
select A.salary,B.name
from Table1 as A
Inner join Table2 as B
on A.id = B.id