A problem with 1 table has 2 foreign key with other table. Help me.

Question

I have 2 tables. Mail and Branch. Tbl Mail include fields: MailCode(PK), FromBranch(FK), ToBranch(FK). Tbl Branch include fields: BranchCode(PK), ZipCode. Fileds FromBranch and ToBranch is FK with BranchCode. Now I wannt to show FromBranch and ToBranch by ZipCode of table Branch. I try query: "select ZipCode As [From Zip Code], ZipCode As [To Zip Code] from Mail As M, Branch As B where B.BranchCode = M.ToBranch and B.BranchCode = M.FromBranch". But it doesn't work. Help me. Thanks

Answer 1

Than you for your reply and I'l  try it.

Answer 2

Knockout JS is a very nice concept, but unlike Telerik, Telerik is a third party tool, which you will integrate into your application to access and use their inbuilt tools that they provide. Telerik is easy and nice to implement. But that is totally different from Knockout.JS.
Now AngularJS has taken the market. They are MVVM approaches. Please follow the links given below. They will surely help you.

http://learn.knockoutjs.com/



http://www.codeproject.com/Articles/806029/Getting-started-with-AngularJS-and-ASP-NET-MVC-Par

I hope these help you learn new techs. I would prefer Angular JS.
Thanks