Issue with retrieving data

[winston1984]

I have the following query. i want to check that the two prices are either the same or with two pence of each other either side, any ideas?

SELECT Ison7.SystemLC, Stock.TotalLandedCost, Ison7.IDPartNumber, Stock.IDPartNumber AS Expr1
FROM Ison7 INNER JOIN
Stock ON Ison7.IDPartNumber = Stock.IDPartNumber AND Ison7.SystemLC <> Stock.TotalLandedCost

 

[dbomrrsm]

SELECT Ison7.SystemLC, Stock.TotalLandedCost, Ison7.IDPartNumber, Stock.IDPartNumber AS Expr1
FROM Ison7 INNER JOIN
Stock ON Ison7.IDPartNumber = Stock.IDPartNumber AND (Ison7.SystemLC BETWEEN Stock.TotalLandedCost - 0.02 AND Stock.TotalLandedCost + 0.02)