[Vserver+V4RB] Querying a table JOINed to itself

[Ruslan Zasukhin]

On 12/15/04 6:06 PM, "Eric Ferrer" <wonderfef at noos.fr> wrote:

>> Try this query
>> 
>> SELECT
>>     N.Name, P.Price
>> FROM
>>     PriceLists N,
>>     PriceLists P
>> WHERE
>>     N.ID *= P.ParentPriceListID
>> AND
>>     (N.Owners LIKE 'TV' AND N.ParentPriceListID = '')
>>   AND
>>     P.ParentArticleID = 'ART123'
> 
> Sorry, I get the same results...
> Only zero prices until I store ALL prices.
> 
> I think I should really think about splitting this table into two different
> ones.
> Unless someone has another idea.

Strange. Seems to be correct.

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