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-03-01') or (EM_dateofJoining <=
'1998-03-30' SqlNew3 = " and isnull(EM_DateOfLeaving)))"
Sqlnew4 = " AND EM_Code NOT IN (Select PFR_Empcode from
PFREPORTTABLE"
Sqlnew5 = " WHERE month(PFR_Date)=2 and year(PFR_Date)=1998"
SqlNew=SqlNew1 & SqlNew2 & SqlNew3 & SqlNew14 & SqlNew5
set rs=dbcon.execute(sqlNew)
When i executing the above statement it gives syntax error.
Is NOT IN statement works in MySql ?
I am having version 3.23.11-alpha of mysql... Is Newer version solves
the problem?
If (NOT IN) statement is not there pls can u send me alternative for
the above sql statements and also suggestion about the version.
Bye,
Prasad.
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-03-01') or (EM_dateofJoining <=
'1998-03-30' SqlNew3 = " and isnull(EM_DateOfLeaving)))"
Sqlnew4 = " AND EM_Code NOT IN (Select PFR_Empcode from
PFREPORTTABLE"
Sqlnew5 = " WHERE month(PFR_Date)=2 and year(PFR_Date)=1998"
SqlNew=SqlNew1 & SqlNew2 & SqlNew3 & SqlNew14 & SqlNew5
set rs=dbcon.execute(sqlNew)
When i executing the above statement it gives syntax error.
Is NOT IN statement works in MySql ?
I am having version 3.23.11-alpha of mysql... Is Newer version solves
the problem?
If (NOT IN) statement is not there pls can u send me alternative for
the above sql statements and also suggestion about the version.
Bye,
Prasad.