SQL语句查询的问题，单个执行没问题，合在一起就见鬼
select * from TreeTb
10会员管理user.aspx UserManage
21会员添加useradd.aspxUserAdd
31会员修改usermod.aspxUserMod
41会员删除userdel.aspxUserDel
50商品管理shop.aspx ShopManage
65商品添加shopadd.aspxShopAdd
75商品修改shopmod.aspxShopMod
85商品删除shopdel.aspxShopDel
90订单管理Order.aspxOderManage
109订单添加orderadd.aspxOderAdd
119订单修改ordermod.aspxOderMod
129订单删除orderdel.aspxOderDel
-----------------------
select [UiTb].UiName from [UiTb]
UserManage
UserAdd
UserMod
UserDel
ShopManage
ShopAdd
ShopMod
ShopDel
OrderManage
OrderAdd
OrderMod
OrderDel
-------------------------
select * from TreeTb where [TreeTb].Duty in(select [UiTb].UiName from [UiTb])
10会员管理user.aspx UserManage
21会员添加useradd.aspxUserAdd
31会员修改usermod.aspxUserMod
41会员删除userdel.aspxUserDel
50商品管理shop.aspx ShopManage
65商品添加shopadd.aspxShopAdd
75商品修改shopmod.aspxShopMod
85商品删除shopdel.aspxShopDel
结果如上，是哪里出错了？？按道理最后的查询因该是 12行数据啊？
[解决办法]
上面是
OderMod
OderDel
下面是
OrderMod
OrderDel
一样么?
