Looks like it worked, thank you. It is definitely an interesting way of doing it although I'm not sure about how I feel about having to make a new entity every time a query like this is used but hopefully it won't be too often.
Thank you for your help. On Wed, Jan 17, 2024 at 11:08 AM Jurgen Doll <jur...@ivoryemr.co.za> wrote: > Ahh, sorry my bad I didn't see the t0 for tableE. > > There may be other ways to do it but I think adding t3.varB as an > attribute to the object entity might be the simplest. > > Regards > Jurgen >