I have 2 tables.

Table1 has columns like

```
ID int
FromAddress int
ToAddress int

```

Table2 has columns like

```
ID int
ZipCode int

```

The Connection between 2 tables is based on FromAddress,ToAdress(from Table1) and ID in table2

Rough data is like in Table1

```
ID     FROMAddress    ToAddress
1      500            620

```

Roughdata is like in Table2

```
ID     ZipCode
500    69999
620    6501

```

I want output like

```
ID     FromZipCode     ToZipCode
1      69999           6501

```

I tried to do Query like

```
Select T1.ID, T2.ZipCode as FromZipCode, T2.ZipCode as ToZipCode
From Table1 T1 join Table2 T2 on T1.FromAddress = T1.ID and T1.ToAddress = T2.ID

```

But this gives me no result.