Select P.PartID, P.mansPart, P.Cost As PartCost, V.PartID, V.PartNo, V.price As VendPrice, M.title, C.CoName, P.FRID
From Parts As P
Right Join Vend2Part As V
On P.PartID = V.PartID And P.FRID = V.FRID
Left Join companies As C
On C.COID = V.COID And C.FRID = V.FRID
Left Join db_manuf As M
On P.manufacturer = M.ManID
Where P.FRID = 0 And P.cost > (V.price * 1.02) or P.cost < (V.price * 0.98) And V.price = (Select Min(Price) From Vend2Part)
Order By P.FRID