Select the first matching record

[FlyingFrog]

Hello friends
I have two tables ProjectInfo and ProjectContacts
A Project can have multile contacts.
I want to retrieve only only contact(any contact) for each projectId.

How can I do this?
Thanks

 

[lienyi]

select ProjectInfo.projID, max(contact)
from ProjectInfo left join ProjectContacts
on ProjectInfo.projID = ProjectContacts.projID
group by ProjectInfo.projID

 

[DavidSL]

The following query will select only the 1st contact for each projID:

Select i.projID, c.contact
from ProjectInfo i left join ProjectContacts c
On i.projID = c.projID
Where c.Contact In (Select Top 1 contact From ProjectContacts where projID = i.projID)

 

[FlyingFrog]

Thanks lienyi and David for your quick response.
David, I followed your approach and it works fine.
thanks again.