A little bit of formatting, aliases and proper syntax you query might look like this.

SELECT p.LastName
, p.FirstName
, d.DeptName
from Professor p
INNER JOIN Department d ON d.DeptCode = p.DeptCode
Where...

haha I saw the same thing.

As a few have pointed out this may or may not work the same depending on the version. It has also long been the standard for the QOTD that unless...

This is just wrong on many levels. The insert doesn't "do nothing". It is however unable to complete because there is a transaction in progress. Once the transaction is resolved...