Re: Problem With NOT IN Sql Statement...

2001-01-12 Thread Rolf Hopkins
sub selects are not yet supported. - Original Message - From: "Nanjunda BM Prasad" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Friday, January 12, 2001 14:57 Subject: Problem With NOT IN Sql Statement... > Hi, > I am having a problem with the sql s

Problem With NOT IN Sql Statement...

2001-01-12 Thread Nanjunda BM Prasad
Hi, I am having a problem with the sql statement when i am trying to execute on MySql the sql statement is : Sqlnew1 = "Select count(EM_Code) as EmpNew FROM employeemaster" Sqlnew2 = " WHERE ((EM_dateofJoining <= '1998-03-30' and EM_dateofLeaving >= '1998-