Untitled

mail@pastecode.io avatar
unknown
mysql
a year ago
370 B
0
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 != ''