How to get records from two tables using ASP.NET

eswar rao

10y915.NET

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

3 Replies

Know the answer? Post it — somebody with the same question will find it here.

eswar rao10y ago
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
0
Joginder Banger10y ago
Hi Rao,

Please share your input and what you want output. I assume table and data

create table staudent(id int,groups varchar(max),batch varchar(max))
create table attendance(id int,absentDate date)
insert into staudent values (1,'AB','ABS'),(2,'ABC','ABB')
insert into attendance values(1,getdate()),(2,getdate())
select staudent.id,groups,batch,absentdate from staudent
inner join attendance on staudent.id=attendance.id order by staudent.groups,staudent.batch,attendance.absentDate

JSB

0
Joginder Banger10y ago
Hi Rao,

Please share your input and what you want output. I assume table and data

create table staudent(id int,groups varchar(max),batch varchar(max))
create table attendance(id int,absentDate date)
insert into staudent values (1,'AB','ABS'),(2,'ABC','ABB')
insert into attendance values(1,getdate()),(2,getdate())
select staudent.id,groups,batch,absentdate from staudent
inner join attendance on staudent.id=attendance.id order by staudent.groups,staudent.batch,attendance.absentDate

JSB

0