sql weirdness

[Dave Parizek]

Ok, so this works:

SELECT ProductName,PriceThere,UsedPrice FROM Item, Venue, Product 
where (Item.ItemProductPtr = Product.RecID) and (VenueItemPtr = 
Item.RecID) and (PriceThere = UsedPrice)

but if I change the last '=' to a '>' or '<' it does not work, I get 
an error 616, wrong expression:

SELECT ProductName,PriceThere,UsedPrice FROM Item, Venue, Product 
where (Item.ItemProductPtr = Product.RecID) and (VenueItemPtr = 
Item.RecID) and (PriceThere > UsedPrice)


What am I doing wrong?

--Dave
-- 
_______________________________________________
Dave Parizek
Bookseller
Dave at Parizek.com