我想出一个办法: (Select flngItemTypeID,'' As flngItemID,fstrItemTypeCode As fstrItemCode,flngItemTypeCode As IndexOne,'' As IndexTwo From ItemType) Union (Select Item.flngItemTypeID,flngItemID,fstrItemCode,flngItemTypeCode As IndexOne,flngItemCode As IndexTwo From Item,ItemType Where Item.flngItemTypeID=ItemType.flngItemTypeID) Order By IndexOne,IndexTwo 大家有什么其他的好主意吗?
谢谢!但是我是要将ItemType和Item中的记录分开显示,而不是显示成一条记录
union
select FLNGITEMTYPEID, ITEM_ID,fstritemcode from Item
我原来采用的就是你的办法,但是这种方法不能将取出的ITEM记录按照编码排序,
这是这个问题的关键所在。
ITEM_ID没有排序是因为你没有要求排序,可以在SQL语句中加上Order By Item_ID子句,甚至可以决定是否升降排序。
例如Item表flngItemID,flngItemTypeID,flngItemCode分别代表商品ID,商品类别ID,商品编码
ItemType表flngItemTypeID,flngItemTypeCode分别代表商品类别ID,商品类别编码.
(Select flngItemTypeID,'' As flngItemID,fstrItemTypeCode As fstrItemCode,flngItemTypeCode As IndexOne,'' As IndexTwo From ItemType)
Union
(Select Item.flngItemTypeID,flngItemID,fstrItemCode,flngItemTypeCode As IndexOne,flngItemCode As IndexTwo From Item,ItemType Where Item.flngItemTypeID=ItemType.flngItemTypeID)
Order By IndexOne,IndexTwo
大家有什么其他的好主意吗?