1. select between用法：
分类id在7和9之间的：
SelectCommand="SELECT top 8 [id], [Clid], [Title], [TitleColor], [Ontop], [Hot], [AddTime] FROM [Article] WHERE [Clid] between 7 and 9 ORDER BY [Ontop], [Hot], [id] desc"
分类id不在7和9之间的：
SelectCommand="SELECT top 8 [id], [Clid], [Title], [TitleColor], [Ontop], [Hot], [AddTime] FROM [Article] WHERE [Clid] not between 7 and 9 ORDER BY [Ontop], [Hot], [id] desc" 2. 同一个select语句获得两个表的内容：
1select A.OrderNum,A.Product_Id,A.BuyPrice,A.ProdUnit,C.Title,C.Buy_Price from OrderDetail A,Products C where A.OrderNum='"&id&"' and A.Product_Id=C.Product_Id"
posted @ 2007-01-15 16:33
ddr888 阅读(426)
评论(2) 编辑 收藏 网摘 所属分类:
数据库