Hi Jeka

We did it before, using a before render code field in the list or item view. This is however quite heavy from cpu point of view but it worked. You can make any SQL query in the code field.

Now we prefer create a new list template

cyril

Hi Cyril and thank for so fast answer. 

So, now you prefer custom list template with some if / else statements?

I not so good to build complex sql queries, but i hearв that LEFT or RIGHT joins can help with achievement of needed result.

It really depends on the result you want to get. You have to think over wether the result may be reusable in another project.

If you can have such a question in a few projects then you definitively need to create a new list template because it will run faster, be more packaged and you won't spend so much time next time.

if there is very few chances to face such a need, then you can use a code field in the seblod list you have. You use the seblod list (with any template you want) to perform the overall search and the code field is there to gather the results according to your criterial.

cyril