oracle问题,7个表联合查询,用sql查出来是的了9条记录,可是DBGrid中显示8条,见鬼了
老子 2006-12-28 07:46:06 SELECT distinct a.uiorderid, a.orderid, a.liveindate, a.leavedate, a.ordertype, a.status, a.ordertime,
b.hotelid, b.hotelname, b.contactman AS affirmman, b.contactfax AS affirmfax, b.remark, b.verifystatus,
c.guestname, c.contactphone AS guestcontphone, c.contactname AS guestcontman, d.contactphone
AS affirmphone, e.operatorname, f.membercode, 1 as querytype, g.notifyway, g.notidest, g.notiphone,
g.status AS notifystatus, g.contsample, g.emailaddr, g.notifytime FROM HTL_R_ORDERBASE a,
HTL_R_ORDERHOTEL b, HTL_R_ORDERGUEST c, HTL_I_AFFIRM d, O_OPERATOR e, M_MEMBER f,
HTL_R_NOTIFYCONTENT g WHERE 1 = 1 AND a.orderid = b.orderid AND a.orderid = c.orderid
AND a.orderid = g.orderid AND b.hotelid = d.hotelid AND a.memberid = f.memberid
AND UPPER (a.orderopercd) = UPPER (e.operatorcd) AND g.notiDest = 0 AND g.status = 0
AND mod( a.orderid,10 ) in (0,1,2,3,4,5,6,7,8,9) AND a.orderopercd like 'csr0000'
order by a.liveindate
查出来9条,在dbgrid中只显示8条,为什么呢