Sub query in Query Builder

Classic Servoy
1

Hi All,

I am pretty much new to Query Builder concept, can anyone please let me know, how to implement below SQL query in Query Builder,

select tbl1.fld1 , (select tbl2.fld2 from tbl2 where tbl2.pk = tbl1.fk) from tabl1

Thanks in advance.

2

Why would you do that with a subquery instead of a join?