sql weirdness

[Ruslan Zasukhin]

on 1/18/04 12:07 AM, Dave Parizek at dave at Parizek.com wrote:

> 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?

Hi Dave,

Valentina 1.x support JOIN by

    WHERE A.key = B.ptr

-- 
Best regards,
Ruslan Zasukhin      [ I feel the need...the need for speed ]
-------------------------------------------------------------
e-mail: ruslan at paradigmasoft.com
web: http://www.paradigmasoft.com

To subscribe to the Valentina mail list go to:
http://lists.macserve.net/mailman/listinfo/valentina
-------------------------------------------------------------