Other point is I think I will need to do some sort of cursor as I showed 2 lines in my table but there might be up to 20 lines...

Thanks I will give that a go.

I think I was trying to be too clever with what I was doing and your short script looks simple but effective.

The SQL statment...

OK perhaps not as clear as it was when I wrote the note 🙂

Table2 can contain a lot more records that I put into the note (up to 1.7 million)...

No I thought of that but it brings back all the records in Table2 even the ones that don't match in Table1

However if I do a Right Outer it seems...

OK

select * from Table2 where Table2.Category(123) in (Select Catergory(123) from Table1)

and Table2.Dimension(888) in (Select Dimension(888) from Table1)

This would show as

Group Name Category Dimension

123 Test 123 888

456 Test1 123...

OK - Basically

Table1 contains fields Groupid, UserName,Category, Dimension

Groupid User Catergory Dimension

AAA Jon 123 ...