1.sqlCmd = 'select tasks_flow.* ’ +
'from tasks_flow ’ +
'where 1=1 and taskstate in (10,20);
2.var sql_getAreas = "SELECT a.*,b.AreaName as Area2Name from (SELECT * FROM area
where Area2Code=? and AreaClass=3) " +
“a LEFT JOIN area
b on a.Area2Code=b.Area2Code and b.AreaClass=2;”;