you have probably already solved this buttttt... for anybody still struggling:
SELECT *
FROM irs.contacts
WHERE full_name = 'DARREN HORTON'
SELECT email, foster_start
FROM txgov.foster_parents
JOIN txgov.foster_parents
where foster_child = 'DARREN HORTON'
SELECT *
FROM irs.death
WHERE full_name = 'KENNETH STAFFORD'
SELECT email
FROM irs.death
WHERE full_name = 'ELSIE PATRICK'
EXEC out ('elsie.patrick@copmail.com')
SELECT *
FROM emails.content
WHERE email_scanned = 'elsie.patrick.copmail.com'