title: How to inverse a statement in SQL server
body: <p>i am designing a stack exchange software and i have this query to retrieve those account name in which my customer has  account  </p>
  
  <pre><code>SELECT TOP (200) account.account_no, account_type.account_type_id, account_type.account_name, customer.first_name
  FROM account 
       INNER JOIN customer ON account.customer_id = customer.customer_id 
       INNER JOIN account_type ON account.account_type = account_type.account_type_id
  WHERE (account.customer_id = 2)
  </code></pre>
  
  <p>And now I want to select Those accounts in which my customer don't have account</p>