JOINing a Table to Itself

Question

I have a list of records (Church Dioceses) in which I would like to pull information into a gridview.

There's 12 priest per diocese but only about 3 are "primary". I need to show only the 3 primaries and I'm unable to figure it out. Any help would do.

 

Here is my code: SELECT [Contact_ID], [First_Name], [Last_Name], [IsPrimary] FROM [Contacts] WHERE (([IsPrimary] = @IsPrimary) AND ([Contact_ID] = @Contact_ID)).

 

FYI: each diocese has it's own unique ID 

 

What Am I doing wrong? please help I'm a newbie. 

 

Thank You