1 select wordbase.name,wb.name,wordconnection.wordid,wordconnection.aid,wordbase.goodsid,goods.hscode,goods.name from wordbase join wordconnection on wordbase.id=wordconnection.wordid ,wordbase wb,goods 2 where wordbase.name=‘THREAD‘ and wb.id=wordconnection.aid and wb.name=‘STEEL‘ and wordbase.goodsid=wb.goodsid and wordbase.goodsid=goods.id 3 select * from wordbase
标记一下，回头删除。
原文：https://www.cnblogs.com/telephoner/p/9108602.html