Delete Query

[yramesh]

delete tst where a.meetingno and lfcode in ( select lfcode,a.meetin gno from tst a
inner join (select centercode, max(meetingno) as meetingno
from grmts
where closedate is null and updateflag<>'D'
group by centercode) b
on a.centercode=b. centercode and a.meetingno>=b. meetingno)

Subquery return multi values i want to delete in single query it is possible

[balame2004]

Try this:

delete tst where a.meetingno and lfcode in ( select Top 1 lfcode,a.meetin gno from tst a
inner join (select centercode, max(meetingno) as meetingno
from grmts
where closedate is null and updateflag<>'D'
group by centercode) b
on a.centercode=b. centercode and a.meetingno>=b. meetingno)


Regards,
Balaji U

[balame2004]

Try this:

delete tst where a.meetingno and lfcode in ( select Top 1 lfcode from tst a
inner join (select centercode, max(meetingno) as meetingno
from grmts
where closedate is null and updateflag<>'D'
group by centercode) b
on a.centercode=b. centercode and a.meetingno>=b. meetingno)


Regards,
Balaji U