Query builder

I am new to Toad Data Point and had some questions regarding query builder. I was hoping to build a query which contains a number conditional joins, is it possible to do this? So far when I have tried to create a select distinct statement within the join it creates a sub query (expected) but when it then comes to joining the sub query I keep gettin unknown column errors. Is query builder able to do this kind of thing? Is there any further guidance out there regarding query builder, it all seems limited and very basic. Thanks

Could you provide more information?

I’m suggesting you need to use CASE statement in the join. Is it correct?

Unfortunately Query Builder does not support such join.