Hi there,
I have tried that query it works, but not good enough.... When you add in Table2 another row with softid 1 and without the string 'test' in it like this : softid | nameofcd 1 test cd 1 2 utils cd 1 3 test cd 2 4 backup id | softid | nameofsoftware 1 1 test software 2 1 software 3 2 software 4 2 software 5 1 software the query you used will give the following result softid nameofcd nameofsoftware 1 test cd 1 1 test cd 1 1 test cd 1 test software 3 test cd 2 Thats incorrect because I want to see only - all cds that matches the string 'test' - all pieces of software that matches the string 'test' So the result has to be like this softid nameofcd nameofsoftware 1 test cd 1 1 test cd 1 test software 3 test cd 2 I hope I have made myself a little bit more clear.... By the way, Thank you for the quick response! Kind regards, Timon Berkowitz The Netherlands