Sub query in Query Builder

[chaitanyas]

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,

Code: Select all

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

Thanks in advance.

[Ruben79]

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