. . "SELECT (SELECT name FROM users WHERE email = 'bobby@tables.com')If the subquery is empty it is converted to the value NULL. Now, if email is a primary key then at most one name will be returned." . .