[Vserver+V4RB] Querying a table JOINed to itself

[Eric Ferrer]

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

Thank you very much
Eric