str:='select basic_info.xh,xm,bj,party_info.qzmm from basic_info,party_info where basic_info.xh=party_info.xh and party_info.qzmm=[color=FF0000]入党积极分子[/color] '; 
入党积极分子是个常量，那应该加单引号还是双引号啊？