SELECT m.*,p.ProductionCompany

from bas_data_market m

LEFT JOIN bas_data_planning p on p.marketSort=m.sort and p.budgetYear=m.budgetYear and p.budgetMonth=m.budgetMonth

LEFT JOIN bas_data_aftersales afts on afts.marketSort=m.sort and afts.budgetYear=m.budgetYear and afts.budgetMonth=m.budgetMonth

LEFT JOIN bas_data_engineering eng on eng.marketSort=m.sort and eng.budgetYear=m.budgetYear and eng.budgetMonth=m.budgetMonth

LEFT JOIN bas_data_manufacture e  ON m.sort=e.marketSort AND m.budgetYear=e.budgetYear AND m.budgetMonth=e.budgetMonth

LEFT JOIN bas_data_market_pricing_application pa on m.sort=pa.sort and m.budgetYear=pa.budgetYear and m.budgetMonth=pa.budgetMonth

 where m.budgetYear='${year}' AND m.budgetMonth='${month}' 

${IF(${fine_username} != 'admin' AND ${fine_username} != '徐莉', " AND m.pm =" ${fine_username},"" )}

order by m.sort ;

如果登录用户不等于admin或者徐莉，则查询m.pm=当前登录用户的数据 ，但是报这个${IF(${fine_username} != 'admin' AND ${fine_username} != '徐莉', " AND m.pm =" ${fine_username},"" )} 语句有语法问题