s.no name 1 sam 2 jhon 3 sonu 4 rams
name date sam 1/12/2011 jhon 1/13/2011 rams 1/13/2012 sonu 1/14/2012 rams 1/15/2012
rams 1/11/2012 rams 1/12/2012 rams 1/14/2012
SELECT name FROM tbl1 WHERE (name NOT IN (select name from tbl2 where (` date` between '" + d1 + "' AND '"+ d2 +"'))) order by name;
SELECT tbl1.name, tbl2.date FROM tbl1 LEFT JOIN tbl2 ON tbl1.name = tbl2.name WHERE tbl2.date NOT between d1 AND d2 order by tbl1.name;
select name from First where Name not in ( select name from Second where date between '2012-01-10' and '2012-01-14') ;
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)