请问这个语句错在那里?谢谢

[msq847]

SELECT distinct ic_supply_card.branchid,
ic_supply_card.newcardid,
ic_supply_card.cardid,
ic_supply_card.status,
ic_supply_card.ttc,
ic_supply_card.tradetime,
ic_supply_card.approvedate,
ic_supply_card.approvenodeid,
ic_supply_card.approveoperator,
ic_supply_card.originalttc,
ic_supply_card.flag,
ic_supply_card.remark,
ic_supply_card.subbranch,
ic_pos.nodeid
FROM ic_supply_card,ic_pos
WHERE ic_supply_card.branchid = :as_branchid AND
ic_pos.nodeid like :as_nodeid AND
ic_supply_card.tradetime >= :ad_start_date AND
ic_supply_card.tradetime <= :ad_end_date and
ic_supply_card.posid = ic_pos.posid
group by ic_pos.nodeid
ORDER BY ic_supply_card.approvenodeid,ic_supply_card.cardid ASC

我想根据ic_pos的nodeid进行查找他的posid 关联另外的一张表
然后按nodeid进行分组 但是结果比想象中的多了一条
去掉group by ic_pos.nodeid结果正常
请问这个语句错在那里?谢谢

[pengchao_214]

建議 你用個子查詢試試

[OracleRoob]

用了distinct，还要用分组?