Untitled

SELECT p.siteflag, r.* FROM (SELECT 
    revolveranumber AS InternalRA,
    ravendornumber AS VendorRANUM,
    ratype,
    rascope,
    priority,
    inputdate,
    expiration,
    productcode,
    scale,
    qty1,
    qty2,
    qty3,
    qty4,
    qty5,
    qty6,
    qty7,
    qty8,
    qty10,
    qty11,
    qty12
FROM
    rarequest
WHERE
    revolveranumber = ''
        AND ravendornumber != ''
        AND ravendornumber != 'x'
ORDER BY inputdate ASC) r
JOIN product p on p.code = r.productcode