• + 1 comment

    What do you mean it doesn't use any joins? Just because the word "join" isn't present doesn't mean there aren't joins. There are other ways to join, and "c.company_code = l.company_code" is an example that works in MySQL (and Oracle).