|
|
|
select t.spcode,t.newspcode,c.pname,d.pname from tb_mobile_sp t ,tb_datadict_collection c ,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 |
|