S
sjm
Unregistered / Unconfirmed
GUEST, unregistred user!
sqlstr = " select * from tb_GoodsType select b.GoodsTypeID,b.GoodsName,a.GoodsTypeName,"
+ "b.GoodsIntroduce,b.GoodsPrice,b.GoodsIsNew from tb_GoodsType"
+ " as a inner join tb_GoodsInfo as b on a.GoodsTypeID=b.GoodsTypeID";
该段代码可以正常执行,但怎么会有两个select,且as部分写法也有点怪。
+ "b.GoodsIntroduce,b.GoodsPrice,b.GoodsIsNew from tb_GoodsType"
+ " as a inner join tb_GoodsInfo as b on a.GoodsTypeID=b.GoodsTypeID";
该段代码可以正常执行,但怎么会有两个select,且as部分写法也有点怪。