sql statement

what i'm trying to do (same db different tables):

currently recruitmentLists.MD_Select is blank and would like to update it with the Member.MD_SelectID values where the records match recruitmentLists.ID and Member.MemberID


what i have so far:

SELECT Member.MD_Select, Member.MD_ID, recruitmentLists.MD_Select, recruitmentLists.ID
FROM recruitmentLists, Member
WHERE recruitmentLists.MD_Select = ' '
SET recruitmentLists.MD_Select = Member.MD_Select
WHERE Member.ID = recruitmentLists.ID


any suggestions?

what i'm trying to do (same db different tables):

currently recruitmentLists.MD_Select is blank and would like to update it with the Member.MD_SelectID values where the records match recruitmentLists.ID and Member.MemberID


what i have so far:

SELECT Member.MD_Select, Member.MD_ID, recruitmentLists.MD_Select, recruitmentLists.ID
FROM recruitmentLists, Member
WHERE recruitmentLists.MD_Select = ' '
SET recruitmentLists.MD_Select = Member.MD_Select
WHERE Member.ID = recruitmentLists.ID


any suggestions?

UPDATE recruitmentLists
SET recruitmentLists.MD_Select = Member.MD_Select
FROM Member
WHERE Member.ID = recruitmentLists.ID