Could someone please tell me where the syntax error is in the SQL Statement? I've attached the statement as an image from SSMS. All the fields are correct as well as the joins. If I replace the @unitType_ID with a valid number and run it...it works fine! I know there is a line underneath the "scaleFactor" column, however, that field does exist.