如前所述，除非使用TOP或FOR XML，否则ORDER BY不得在子查询中使用。
SELECt TOP 10 * FROM ( SELECt c.id, c.name, c.inserteddate, c.cityname, ftblstates.name AS statename, clc.name AS catname, '' AS listingimagelogo, '' AS orgname, relocateyn, '' AS employerclassified FROM tblclassifieds c LEFT JOIN tblclassifiedscategories clc ON c.categoryid = clc.id LEFT JOIN ftblstates ON c.stateid = ftblstates.id WHERe c.expirydate != '' AND NOT c.id IN ( SELECt TOP 10 tblclassifieds.id FROM tblclassifieds WHERe c.expirydate != '' ORDER BY inserteddate desc ) UNIOn ALL SELECt ce.id, ce.name, ce.inserteddate, suburb AS cityname, ftblstates.name AS statename, ce.jobtype AS catname, ce.listingimagelogo, ce.orgname, '' AS relocateyn, '1' AS employerclassified FROM tblclassifiedemployers ce LEFT JOIN ftblstates ON ce.stateid = ftblstates.id WHERe ce.expirydate != '' AND NOT ce.id IN ( SELECt TOP 10 tblclassifiedemployers.id FROM tblclassifiedemployers WHERe ce.expirydate != '' ORDER BY inserteddate desc )) a ORDER BY inserteddate desc;
