|
t0.*,t1.name as protypecn,(select valuecn from dictionary where classname='product' and attributename='unit' and value=t0.unit1) as unit1cn,(select valuecn from dictionary where classname='product' and attributename='unit' and value=t0.unit2) as unit2cn,(select valuecn from dictionary where classname='product' and attributename='unit' and value=t0.unit3) as unit3cn,(select valuecn from dictionary where classname='product' and attributename='unit' and value=t0.unit4) as unit4cn
上面是查询SQL,但是baasdata字段里只看到t0表的字段 |
|