Why use a nested query, not directly with equal join?

CodePudding user response:

You write their own dept table, simply does not appear in the update, affirmation won't work,