Loading

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

tuanbs

17y2.9k

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

1 Reply

Know the answer? Post it — somebody with the same question will find it here.

Mr JBG17y ago
Accepted answer
select C.ZipCode As [From Zip Code], B.ZipCode As [To Zip Code]
from Mail As M, Branch As B, Branch As C
where B.BranchCode = M.ToBranch and C.BranchCode = M.FromBranch
0