FROM            shipments   S 
INNER JOIN      products    P   ON S.productId = P.productID  
LEFT OUTER JOIN customers   C   ON S.companyId = C.customerId AND S.ShipmentType = 'export'
LEFT OUTER JOIN suppliers   SP  ON S.companyId = SP.supplierId AND S.ShipmentType = 'import'