Tech
Forums
Jobs
Books
Events
Interviews
Live
More
Learn
Training
Career
Members
Videos
News
Blogs
Login
Sign Up
Ask Question
8
Reply
Getting Data from two tables
Mark Tabor
Jun 12 2016 11:28 AM
455
Reply
I have two tables one of USERS and second of UserFiles just like below
UserTable
UserId
Name
Email
Phone
1
New
[email protected]
0909000
2
Old
[email protected]
0998099
UserFiles
FileID(Primary)
UserID(Foreignkey)
FileName
DateCreated
Active
1
1
MyResume.Doc
2/2/2016
true
2
1
Image.JPG
2/17/2016
true
3
1
Cover.Docx
2/20/2016
true
4
2
Card.png
1/1/2017
true
Now I have a gridview I want to show one File for each user I mean the latest file for this user According to datecreated for example here I have three files for userid=1 but i just want to show the Cover.Docx because it is latest one for this user according to datecreated Field.
I want this record how to do that
RecordID
UserId
FileName
Email
Phone
1
1
Cover.Docx
[email protected]
0909000
2
2
card.png
[email protected]
0998099
I want that record how to achived that
Upload Source Code
Select only zip and rar file.
Post
Reset
Cancel
Answers (
8
)
Next Recommended Forum
Using IF else statements in stored procedure
record not delete if id use another table in sql query