Untitled

mail@pastecode.io avatar
unknown
mysql
a year ago
427 B
5
Indexable
Never
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