Procedure With Joins

Hi,

I need to write a procedure that retrieves a list of contacts from a contact table, in which the contact types are stored by id; I only want the contacts that are a certain contact type [prospector], but I want to use the contact type name, not ID to compare because that should never change, while the ID could change. Another table contains the contact types with ID's to link them to the contact table. Here is the code I use, but when I retrieve the information from the procedure using a page online, the page stops loading after the procedure is executed:

--------------------- CODE -------------------
CREATE Procedure getProspectors

AS

SELECT
[contact table].ID,
[contact table].contact

FROM [contact table]

INNER JOIN [contact types table] ON
[contact table].contactType = [contact types table].ID

WHERE [contact types table].contactType = 'prospector'

ORDER BY contact ASC


RETURN
GO
---------------------- END CODE ----------------

I don't really know that much about SQL - I copied the idea from some other procedures. Is there a reason why this wouldn't work?

thanks,
melloamokb