sbSql = sbSql.Append(" select")
sbSql = sbSql.Append(" t1.ShopID ShopID")
sbSql = sbSql.Append(" ,t1.Name GoodsName")
sbSql = sbSql.Append(" ,t1.Kbn Kbn") '原表名
sbSql = sbSql.Append(" ,t1.Price Price")
sbSql = sbSql.Append(" ,t1.SalePrice SalePrice")
sbSql = sbSql.Append(" ,t1.BuyPrice BuyPrice")
sbSql = sbSql.Append(" ,t1.MakerID MakerID")
sbSql = sbSql.Append(" ,t1.SaleDay SaleDay")
sbSql = sbSql.Append(" ,t1.SaleFlg SaleFlg")
sbSql = sbSql.Append(" ,t2.Name MakerName")
sbSql = sbSql.Append(" ,t3.CodeValue KbnName")
sbSql = sbSql.Append(" ,t4.CodeValue SaleFlgName")
sbSql = sbSql.Append(" from shop t1, Maker t2, Code t3, Code t4")
sbSql = sbSql.Append(" where")
sbSql = sbSql.Append(" t1.MakerID = t2.MakerID")
sbSql = sbSql.Append(" and t3.CodeKbn = '03'")
sbSql = sbSql.Append(" and t3.Code = t1.Kbn")
sbSql = sbSql.Append(" and t4.CodeKbn = '04'")
sbSql = sbSql.Append(" and t4.Code = t1.SaleFlg")
sbSql = sbSql.Append(" and t1.Delflg = '0'")
sbSql = sbSql.Append(" and t1.Kbn like ?t1.Kbn")
sbSql = sbSql.Append(" and t1.Name like ?t1.Name")
sbSql = sbSql.Append(" and t1.SaleDay >= ?t1.SaleDayS")
sbSql = sbSql.Append(" and t1.SaleDay <= ?t1.SaleDayE")
sbSql = sbSql.Append(" and t2.Name like ?t2.Name")
sbSql = sbSql.Append(" order by GoodsID")
帮忙看看这些代码,里面的 sbSql = sbSql.Append(" t1.ShopID ShopID")是什么意思啊?由其不明白里面的 "t1.ShopID"为什么要这样写?高手帮帮忙,多谢了!
sbSql = sbSql.Append(" t1.ShopID ShopID")
sbSql = sbSql.Append(" ,t1.Name GoodsName")
sbSql = sbSql.Append(" ,t1.Kbn Kbn") '原表名
sbSql = sbSql.Append(" ,t1.Price Price")
sbSql = sbSql.Append(" ,t1.SalePrice SalePrice")
sbSql = sbSql.Append(" ,t1.BuyPrice BuyPrice")
sbSql = sbSql.Append(" ,t1.MakerID MakerID")
sbSql = sbSql.Append(" ,t1.SaleDay SaleDay")
sbSql = sbSql.Append(" ,t1.SaleFlg SaleFlg")
sbSql = sbSql.Append(" ,t2.Name MakerName")
sbSql = sbSql.Append(" ,t3.CodeValue KbnName")
sbSql = sbSql.Append(" ,t4.CodeValue SaleFlgName")
sbSql = sbSql.Append(" from shop t1, Maker t2, Code t3, Code t4")
sbSql = sbSql.Append(" where")
sbSql = sbSql.Append(" t1.MakerID = t2.MakerID")
sbSql = sbSql.Append(" and t3.CodeKbn = '03'")
sbSql = sbSql.Append(" and t3.Code = t1.Kbn")
sbSql = sbSql.Append(" and t4.CodeKbn = '04'")
sbSql = sbSql.Append(" and t4.Code = t1.SaleFlg")
sbSql = sbSql.Append(" and t1.Delflg = '0'")
sbSql = sbSql.Append(" and t1.Kbn like ?t1.Kbn")
sbSql = sbSql.Append(" and t1.Name like ?t1.Name")
sbSql = sbSql.Append(" and t1.SaleDay >= ?t1.SaleDayS")
sbSql = sbSql.Append(" and t1.SaleDay <= ?t1.SaleDayE")
sbSql = sbSql.Append(" and t2.Name like ?t2.Name")
sbSql = sbSql.Append(" order by GoodsID")
帮忙看看这些代码,里面的 sbSql = sbSql.Append(" t1.ShopID ShopID")是什么意思啊?由其不明白里面的 "t1.ShopID"为什么要这样写?高手帮帮忙,多谢了!
为了区分多个表,每个表取一个不同的别名,即t1、t2、t3等,t1就是一个表;
如果这些表里都有ShopID这个字段,那么如何区分呢,就要加上t1.的前缀,指t1表中的ShopID字段,当然,都加上t1的前缀可以提高可读性,并不一定是因为每个表都有这么一个字段;
t1.ShopID ShopID后面的这个ShopID,就是这个字段的别名,即在下面的SQL语句中,ShopID就是t1.ShopID了。
不知道我说清楚了没有