Hi everybody,

I'm just wondering what would be better in your opinion:

SELECT Registration.*, Schools.SchoolPhone
		FROM dbo.Registration LEFT JOIN Schools ON Registration.School = Schools.School 
AND Schools.SiteID = @SiteID
        WHERE RegistrationID = @RegistrationID

or

SELECT Registration.*, Schools.SchoolPhone
		FROM dbo.Registration LEFT JOIN Schools ON Registration.School = Schools.School 
AND Registration.SiteID = Schools.SiteID
        WHERE RegistrationID = @RegistrationID

In 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.

Thanks a lot in advance.

On the second thought - why do I care for one record return? LOL.