Hi there, Sorry for being a little bit confusing, but de criterias has to be AND.
So it has to be like this: - all cds that matches the string 'test' AND - all pieces of software that matches the string 'test' Kind regards, Timon Berkowitz The Netherlands ""Peter Brawley"" <[EMAIL PROTECTED]> schreef in bericht news:[EMAIL PROTECTED] > 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 > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]