Index Exchange Interview Question: Given 2 SQL tables: users with (name,userid), blacklist with (userid), create a sql query that will only allow non-blacklisted users to login.

Notifications

Index Exchange

Given 2 SQL tables: users with (name,userid), blacklist with (userid), create a sql query that will only allow non-blacklisted users to login.

Anonymous

10 Apr 2016

Try to avoid language specific syntax; they use MySQL, so that would be a good place to start.

Anonymous

13 Apr 2016

using a left join and where blacklist.user is null