title: Syntax Error but not sure why (SQL Server)
body: <pre><code>INSERT into LibraryTable(ID, Artist, Name, Rating, PlayCount) VALUES(
  Select MIN(a.ID + 1)
  From LibraryTable A
  Left Join LibraryTable B
  On A.ID = B.ID - 1
  Where B.ID Is NULL, 'eg', 'eg', 1, 1)
  </code></pre>
  
  <p>im getting a syntax error at "Select" and the "," after null. im a beginner so any helpful tips would be greatly  appreciated. </p>