Query giving unexpected results.

[Ruslan Zasukhin]

On 9/10/04 7:26 PM, "Bill Numerick" <bnumerick at gmail.com> wrote:

> Thanks for the reply Ruslan.
> 
> Ok I changed the query like you suggested and its returning even more
> results than before.  It looks like its not taking the
> optional_feature.of_type = 'Exteriors' .  Here's the full query with
> the from this time ;).
> 
> SELECT optional_feature.id,
> optional_feature.name,model_optional_feature.msrp,model_optional_feature.paren
> t_id
> FROM model, optional_feature, model_optional_feature WHERE   (model.id
> = model_optional_feature.model_id AND
> model_optional_feature.optional_feature_id = optional_feature.id) AND
> (model.id = '59' AND optional_feature.of_type = 'Exteriors' AND NOT
> optional_feature.id in (16,17,18,20,21,56,99,163,203,204,242) ) ORDER
> BY optional_feature.name ASC

Well, I need db, and I will test in in viSQL or in VStudio.


> So are you saying 2 isn't as picky? :).

Yes, in 2.0 we have resolve this problem.

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