zhaozhaode(提问者)SELECT distinct b.sParaName
FROM dbo.Para_erecord AS a INNER JOIN
dbo.Para_type AS b ON a.fkiParaID = b.ID INNER JOIN
dbo.workstation_type AS c ON b.fkiWorkstationID = c.ID INNER JOIN
dbo.zone_type AS d ON c.sZoneName = d.sZoneName
${if(len(zone) == 0,\"\",\"and d.sZoneNameDes = \'\" + zone + \"\'\")}
${if(len(workstation) == 0,\"\",\"and c.sWorkstationName = \'\" + workstation + \"\'\")}
做的参数联动