请各位高手帮小弟建个视图，在线等待！

Question

create view as SELECT                 rownum,a.SECOND_ID,a.SECOND_NO,a.SECOND_CLASSID,a.SECOND_TRADE,a.SECOND_ZONE,a.SECOND_VILLAGE,a.SECOND_POSITION,a.SECOND_PURPOSE,a.SECOND_TYPE,a.SECOND_FLOOR,a.SECOND_AREA,a.SECOND_YEARS,a.SECOND_PRICE,a.SECOND_DETAIL,a.SECOND_PUBLISHER,a.SECOND_DATE,a.SECOND_IP,a.SECOND_HIT,a.SECOND_PERSON,a.SECOND_ADDRESS,a.SECOND_TELEPHONE,a.SECOND_TAX,a.SECOND_EMAIL,a.SECOND_OTHER,a.SECOND_VALIDATE,a.MEMBER_USERID,b.CLASS_NAME     FROM
               SECOND_HOUSE a
     LEFT JOIN
               SECOND_HOUSE_CLASS b
     ON 
               a.SECOND_CLASSID = b.CLASS_ID
     WHERE
               a.SECOND_CLASSID = :SECOND_CLASSID
     ORDER BY
               a.SECOND_DATE
     DESC

Answer 1

那就把:SECOND_CLASSID改成对应的就可以了