//t1 为主表，t2为子表
SELECT t1.*,t2.*
FROM TABLENAME1 t1,TABLENAME2 t2 WHERE t1.ID = t2.PIDAND t2.PID IN(SELECT ID FROM(SELECT ID,rownum FROM TABLENAME1 WHERE rownum <=pageNum*pageSize) WHERE rownum > (pageNum-1)*pageSize)
ORDER BY t1.VC_DATE DESC
//t1 为主表，t2为子表
SELECT t1.*,t2.*
FROM TABLENAME1 t1,TABLENAME2 t2 WHERE t1.ID = t2.PIDORDER BY t1.VC_DATE DESC
