Tech
Forums
Jobs
Books
Events
Videos
Conference
Annual Conference
Bcrypt
Ai Conference
Live
More
Interviews
Certification
Training
Career
Members
News
Blogs
Contribute
An Article
A Blog
A Video
An Ebook
An Interview Question
Register
Login
3
Answers
How to get records from two tables using ASP.NET
Ask a question
Ask a question
Upload Source Code:
Select only zip and rar file.
eswar rao
8y
347
1
Reply
hi friends ,
i have a one problem..that is i have two tables .
1.student 2 .attendance
i want results from two tables ..i mean who's absent on particular date and group and batch..
student tables is haveing (id,group,batch)
attendance table having (id,date)
i want absentees data with sorting by group and batch and date..please tell me how to write a query for that..
What I have tried:
SELECT id,gender,vid,fname,mobino,fathername,date,batch,group,FROM tbl_studentenroll ee WHERE not exists (SELECT vid,date FROM tbl_attendance aa where aa.vid=ee.vid and aa.date='" + ddl_date.SelectedItem.Text + "' and ee.group='" + ddl_group.SelectedItem.Text + "' and ee.batch='" + ddl_batch.SelectedItem.Text + "' );
but it is not sorting results it is shows all groups and batchs absents
Post
Reset
Cancel
Answers (
3
)
Next Recommended Forum
How to bind image with radiobutton?
Dataset is not filling when i am uploading on windows8 IIS.