title: Why 'should I' or 'shouldn't I' use JOINs in this SQL query?
body: <p>Here is my SQL query:</p>
  
  <pre><code>SELECT FirstName,
         LastName
  FROM Employee,
       Company,
       State,
       Job
  WHERE Employee.CompanyID = Company.CompanyID
    AND Company.StateID = State.StateID
    AND State.Abbreviation = 'FL'
    AND Employee.JobID = Job.JobID
    AND (Job.JobCode = 'dev'
         OR Job.JobCode IS NULL)
  ORDER BY LastName ASC,
           FirstName ASC;
  </code></pre>
  
  <p>I am wondering if I should use JOINs for increased efficiency. I am not well versed in query complexity.</p>
  
  <p>I found many sites useful in developing my query such as:</p>
  
  <ul>
  <li><a href="https://sqlformat.org" rel="nofollow noreferrer">https://sqlformat.org</a></li>
  <li><a href="https://stackoverflow.com/questions/1018822/inner-join-on-vs-where-clause">INNER JOIN ON vs WHERE clause</a></li>
  <li><a href="https://logicalread.com/use-sql-server-joins-or-subqueries-mc03/" rel="nofollow noreferrer">https://logicalread.com/use-sql-server-joins-or-subqueries-mc03/</a></li>
  <li><a href="https://www.w3schools.com/sql/sql_null_values.asp" rel="nofollow noreferrer">https://www.w3schools.com/sql/sql_null_values.asp</a></li>
  </ul>
  
  <p>Thank you for your assistance.</p>