select * from tbl_SEC_MemGrpLink lnk left outer join tbl_FSPRO_Members mem on lnk.fspro_userId = mem.fspro_userId where mem.ownerId = 99 and mem.fsl_tablecode = 'MSC' and lnk.groupId = 5851 select * from tbl_SEC_MemGrpLink lnk left outer join tbl_FSPRO_Members mem on lnk.fspro_userId = mem.fspro_userId where mem.ownerId = 99 and mem.fsl_tablecode = 'MSC' and lnk.groupId = 5311 and lnk.fspro_userId = insert into tbl_SEC_MemGrpLink ( fspro_userId, groupId ) values ( , 5311 )