Re: Determine if range list contains specified integer

On 5/27/22 03:51, Andrus wrote:
> Hi!

> How to all properties for given type.
> Query
> 
>      select id
>      from artliik
>      join strings on ','||trim(strings.kirjeldLku)||',' like 
> '%,'||trim(artliik.liiginrlki)||',%'
> 
> returns date for single integer list only.
> How to change join so that type ranges in list like 6-9 are also returned?
> Eq. f list contains 6-9, Type 6,7,8 and 9 shoud included in report.

Start over with a more rational data model.

> Andrus.
> 


-- 
Adrian Klaver
adrian.klaver@aklaver.com