最近学习的sql查询语句连接查询,标记一下

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

标记一下,回头删除。

posted on 2018-05-29 23:40  马维拉的真实之眼  阅读(334)  评论(0编辑  收藏  举报

导航