[Resolved] MySQL SELECT Query Filter out the ban list

jnuneznyc

I have 3 tables and I need to retrieve a list of users from table Users and send them a notice. But I need to suppress emails to the users listed in tables BlockUsers and BlockDept.

TABLE: USERS
ID - Integer
UserName - varchar(100)
FirstName - varchar(50)
LastName - varchar(50)
Department - varchar(100)

TABLE: BlockUsers
UserName - varchar(80) --Yes I know this doesn't match but I didn't create this DB but I have to support it.
BlockReason - text

TABLE: BlockDept
ID - Integer
Department - varchar(100)
BlockReason - Text

So I just need the users who are not blocked and their department is not blocked.

kevinsequeira

select USERS.UserName from USERS, BlockUsers, BlockDept where USERS.Username!=BlockUsers.UserName AND USERS.Department!=BlockDept.Department

reg
kevin

stolzyboy

select USERS.UserName from USERS, BlockUsers, BlockDept where USERS.Username != BlockUsers.UserName AND USERS.Department != BlockDept.Department

jnuneznyc

Thanks Kevin that worked....

Note: will using Left Join be faster?

stolzyboy

technically it is a left join, but it does it by default even if you don't specify

jnuneznyc

Thanks Stolz....

I meant to thank you too... I never tried your response since the first one worked.

Thanks again
jnuneznyc