Error in Query : select ps.iPhysicianPId from physician_specialty ps left join  physician_profile pp on ps.iPhysicianPId=pp.iPhysicianPId where pp.vDegree <> 'APRN' AND ps.iSpecialtyId in () order by pp.vLastName <br>1064 : You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ') order by pp.vLastName' at line 1