I am now thinking of breaking table1 up so that it is the following:

table1:

column name: GroupID TableID

row:              1          1

row:              2          1

row:              3          2

table2:

column name: GroupID Type   Value

row:             1          Type1 6

row:             1          Type2 7

row:             2         ...

Hi Peter

Thanks for this. It works great when I know what the name of table2 is. I have an extra complication in that I don't know up front what table...

I should have added, cursors are very much a last resort. I want to do this as a straight set of joins if possible.

Thanks

Brad