title: Query to exclude all values of a table in MySQL
body: <p>im new to MySQL so please help me about this problem
  This is my current SQL to search for new open accounts:</p>
  <p><code>SELECT ifnull(ib.team,'Retail') Team, count(distinct usr.login) ACC_OPENED</code>
  <code>FROM MT4_USERS usr</code>
  <code>LEFT JOIN ibheirachytemp ib ON ib.login=usr.agent_account</code>
  <code>WHERE usr.REGDATE BETWEEN '2022-03-24 00:00:00' AND '2022-03-24 23:59:59'</code><br />
  <code>AND usr.name NOT LIKE '%Acc%'</code>
  <code>AND usr.login between 600000 and 900000</code>
  <code>AND usr.group NOT LIKE '%P5%'</code>
  <code>AND usr.group NOT LIKE '%MF%'</code>
  <code>AND usr.group NOT LIKE '%Test%'</code>
  <code>AND usr.login not in (1014,9999,60006035,60006131,60008108,60001078,60007308,60000133,60007304,60006591,60007362,60005193,60007308)</code></p>
  <p><code>GROUP BY ib.team;</code></p>
  <p>The problem is more more test account is created, and the &quot;usr.login not in...&quot; keep getting longer
  so i created a new table &quot;TestAccounts&quot; contain 2 columns &quot;Login&quot; and &quot;Name&quot;
  Now, how do i write the query to exclude all the values(login and name) from this &quot;TestAccounts&quot; table?</p>
  <p>Thanks you</p>
  <p>i have tried to google first, but seem like there is no question for now, please help me if you can</p>