M
meijingpengwork
Unregistered / Unconfirmed
GUEST, unregistred user!
数据库中统计出来<br>SELECT a.NO,a.d_date, b.name,b.num,b.weight FROM Tablea a LEFT JOIN Tableb b<br> ON a.NO= b.NO<br>NO DATE name num weight <br>1 2008-02-02 黄金 1.0 8.8 <br>2 2007-01-01 水晶 2.0 9.9 <br>3 2008-11-11 钻石 3.0 9.8 <br>如何统计出 按name分类的 excel导入的格式<br> 黄金 水晶 钻石<br>NO DATE NUM WEIGHT NUM WEIGHT NUM WEIGHT <br>1 2008-02-02 2.0 16 <br>2 2007-01-01 2.0 9.9<br>3 2008-11-11 3.0 9.8