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