Subject Subselect vs. JOIN
Author Nico Callewaert <>

I was hoping to find a already posted answer in this group, but it
seems not. The question is : I wonder when it's better to use a
subselect or a join ? When I need only 1 field from a table I use
a subselect, when I use several fields I use a join. Is that
correct ? Because I think in a subselect you can only get 1
field ? I wonder which one is the most performant ?

Thanks in advance, Nico Callewaert