[Vserver+V4RB] Querying a table JOINed to itself

[Eric Ferrer]

Ruslan

>> SELECT
>> N.Name, P.Price
>> FROM
>> PriceLists N,
>> PriceLists P
>> WHERE
>> N.Owners LIKE 'TV'   ''this is specific to my app
>                         ^^^^^^^^^^^^^^^^^^^^^^^^ this is comment ?
> 
> Valentina not support comments in SQL query

Yes, I know ;-)
I added this comment in my email just to make my SQL example clearer.
Of course, there is no comment nor carriage return in my real SQL statement!

> 
>> AND
>> N.ParentPriceListID = ''      '' to get price list name
>> AND
>> N.ID *= P.ParentPriceListID
>> AND
>> P.ParentArticleID = '123ABC'

Eric