SELECT oi.*
FROM Customer c, "Order" o, OrderItem oi, ItemDetail id, ItemSku isk, VendorSku vs, Vendor v, Sku s
WHERE c.customerId = o.customerId
AND o.orderId = oi.orderId
AND oi.itemDetailId = id.itemDetailId
AND id.itemId = isk.itemId
AND isk.skuId = vs.skuId
AND isk.skuId = s.skuId
AND vs.vendorId = v.vendorId
AND v.vendorName = 'Vendor 1'
AND s.sku in ('SKU1', 'SKU3')
AND c.customerNumber in ('100', '200', '300', '400', '500', '600', '700', '800', '900');