I'm trying to get help writing a query from scratch SQL.


Here is Question:

Find email addresses dbo.[EmailAdresses] that are not associated with any person dbo.[Person]. Return [EmailAddress] and [EmailAddressID] from the table dbo.[EmailAdresses]. Provide different requests using LEFT, RIGHT JOINs and without joining tables

Its all for study? i want to become professional worker with databases, but sometimes i cant find answers on my questions=(


SELECT EmailAddress FROM dbo.[EmailAdresses] NOT LIKE not idea

SELECT EmailAddress, EmailAddressID FROM dbo.[EmailAdresses]

| improve this answer | |

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.