Mapping two tables

[Guest]

I need some help mapping two tables

Example of Table One

Name Rate Recovery_Rating
Tom 2 A
Peter 3 B
Jane 4 C
John 5 D

Example of Table Two


Recovery_Rating LGD_Class Loss %
A A1 0
B B1 0.05
C C1 0.1
D E1 0.2
E F1 0.3
F G1 0.35
G L1 0.45
X L1 0.45
S L1 0.45
H M1 0.55
I N1 0.7

In my new table or query I would like to add two new columns to table one
and Populate it with the data from Table Two

For example it there is a match in Recovery_Rating column form table one and
two then add the data

So the new table should look like this

Name Rate Recovery_Rating LGD_Class Loss %
Tom 2 A A1 0
Peter 3 B B1 0.05
Jane 4 C C1 0.1
John 5 D E1 0.2



Thanks

Chris

 

[Marshall Barton]

I need some help mapping two tables

Example of Table One

Name Rate Recovery_Rating
Tom 2 A
Peter 3 B
Jane 4 C
John 5 D

Example of Table Two


Recovery_Rating LGD_Class Loss %
A A1 0
B B1 0.05
C C1 0.1
D E1 0.2
E F1 0.3
F G1 0.35
G L1 0.45
X L1 0.45
S L1 0.45
H M1 0.55
I N1 0.7

In my new table or query I would like to add two new columns to table one
and Populate it with the data from Table Two

For example it there is a match in Recovery_Rating column form table one and
two then add the data

So the new table should look like this

Name Rate Recovery_Rating LGD_Class Loss %
Tom 2 A A1 0
Peter 3 B B1 0.05
Jane 4 C C1 0.1
John 5 D E1 0.2

SELECT Table1.[Name], Table1.Rate, Table1.Recovery,
Table2.LGD, Table2.Loss
FROM Table1 INNER JOIN Table2
ON Table1.Recovery = Table2.Recovery