I have a table with a list of records in it with an ID and a name.

I have another table that has an ID, a value, and also the ID from the first table. I am trying to make a view of the second table, but it needs to show the ID from the first table in different columns if they are different.

For example
in table A

ID NAME
1 A
2 B

Table 2
ID VALUE Tble1ID
1 1 1
1 1 2
2 2 1
2 2 2

View I need:
ID A B
1 1 1
2 2 2

How can I do this.

Chris

__________________
Chris