[Vserver+V4RB] Querying a table JOINed to itself

[Ruslan Zasukhin]

On 12/15/04 11:59 AM, "Eric Ferrer" <wonderfef at noos.fr> wrote:

Hi Eric,

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'

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