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(dot)klaver(at)aklaver(dot)com