Tech
Forums
Jobs
Books
Events
Videos
Live
More
Interviews
Certification
Training
Career
Members
News
Blogs
Contribute
An Article
A Blog
A Video
An Ebook
An Interview Question
Register
Login
4
Answers
join tables in sql server
Santosh Sasupalli
8y
295
1
Reply
i have 2 tables
base:
Id int
Name Varchar
and values in base:
1 abc
2 cde
3 def
Sub:
sid int
CreatedBy Id(From base table Id)
ModiFiedBy Id(From base table Id)
and values in sub
1 2 3
2 1 2
3 3 2
now i want table like this
sid CreatedBy CreatedByName ModifiedBy ModifiedByName
1 2 cde 3 def
2 1 abc 2 cde
3 3 def 2 cde
how to write this query please help me
Post
Reset
Cancel
Answers (
4
)
Next Recommended Forum
Download Excel file on button click in windows form
store files in database