Tech
Forums
Jobs
Books
Events
Live
Interviews Prep
More
Learn
Training
Career
Members
Videos
News
Blogs
Login
Sign Up
Ask Question
4
Reply
join tables in sql server
Santosh Sasupalli
Sep 17 2016 11:14 AM
279
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
Upload Source Code
Select only zip and rar file.
Post
Reset
Cancel
Answers (
4
)
Next Recommended Forum
Download Excel file on button click in windows form
store files in database