How to get records from two tables using ASP.NET

Question

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 (idgroupbatch) attendance table having (iddate) 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 idgendervidfnamemobinofathernamedatebatchgroupFROM tbl_studentenroll ee WHERE not exists (SELECT viddate 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

eswar rao · Answer

Thank you for given reply...But it is not showing what i want ...i want absents data..it is shows all groups of presents data..please tele me

Joginder Banger · Answer

Hi Rao Please share your input and what you want output. I assume table and data create table staudent(id intgroups varchar(max)batch varchar(max)) create table attendance(id intabsentDate date) insert into staudent values (1'AB''ABS')(2'ABC''ABB') insert into attendance values(1getdate())(2getdate()) select staudent.idgroupsbatchabsentdate from staudent inner join attendance on staudent.id=attendance.id order by staudent.groupsstaudent.batchattendance.absentDate JSB

Joginder Banger · Answer

Hi Rao Please share your input and what you want output. I assume table and data create table staudent(id intgroups varchar(max)batch varchar(max)) create table attendance(id intabsentDate date) insert into staudent values (1'AB''ABS')(2'ABC''ABB') insert into attendance values(1getdate())(2getdate()) select staudent.idgroupsbatchabsentdate from staudent inner join attendance on staudent.id=attendance.id order by staudent.groupsstaudent.batchattendance.absentDate JSB