MVC c# web服务连接两个表并组合输出。

I am working on iTunes/amazon/googlePlay affiliate program and want to add the AffiliateCode to the URL i have in my ExternalLinks Table within the web service. This means that the webservice first collects with the id_cd the different available links from the ExternalLinks[Table] and after is needs to loop over the AffiliateProgram[Table] for each of them to compare if there is a matching affiliate program available.I am working on iTunes/amazon/googlePlay affili