Timon, What is unclear to me is whether you wish to AND or OR your two criteria ...
>- all cds that matches the string 'test' >- all pieces of software that matches the string 'test' so if your table2 had (6, 2, 'test'), where table1.nameofcd for softid=2 does not contain 'test', do you want it in your result? PB ----- Original Message ----- From: Timon Berkowitz To: [EMAIL PROTECTED] Sent: Tuesday, March 30, 2004 12:34 PM Subject: Re: Difficult query and am kinda stuck how to continue can someone help? 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
