SELECT Registration.*, Schools.SchoolPhone FROM dbo.Registration LEFT JOIN Schools ON Registration.School = Schools.School AND Schools.SiteID = @SiteID WHERE RegistrationID = @RegistrationIDor
SELECT Registration.*, Schools.SchoolPhone FROM dbo.Registration LEFT JOIN Schools ON Registration.School = Schools.School AND Registration.SiteID = Schools.SiteID WHERE RegistrationID = @RegistrationIDIn other words, is it better to use parameter or field value? In the first case I would need to adjust several pages to add an extra parameter.