QAD BI v3 – Tech Level 2 Certification - Part 1 > SQL – Preview > SQL to Avoid – Select within Select
  PPT
SQL to Avoid – Select within Select
 
With this, each row would generate another search on the table to make the match in order to do a sum. For something like this it’s better to just join the tables in the where clause.