Untitled
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 != ''