多表关联查询
select t.spcode,t.newspcode,c.pname,d.pname from tb_mobile_sp t ,tb_datadict_collectionc ,tb_datadict_collection dwhere c.spbusitype='Mobile' and c.property='SPType' and t.sptype=c.pvalueand d.spbusitype='Mobile' and d.property='Status' and t.status=d.pvalue
页:
[1]