The exists with the not exists the usage of the difference between
USE pubs
SELECT DISTINCT city
FROM the authors
WHERE the EXISTS
(SELECT *
The FROM publishers
WHERE the authors. The city=publishers. City),
Why must be in the where to write the authors. The city=publishers. The city, and without written records will not come?

CodePudding user response:

After the need to focus on, now but first, let me help you

CodePudding user response:

Pick up points is king!

CodePudding user response:

Are all very good advice! Worth learning