.
So the table which has to be generated has to be like this
softid nameofcd nameofsoftware
1 test cd 1
1 test cd 1test software
3 test cd 2
I want to know is this possible to make? And if so.. can someone make the query as
well?
Kind regards,
Timon Berkowitz
The Netherlands
e like this
softid nameofcd nameofsoftware
1 test cd 1
1 test cd 1test 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
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
"
vious!
As always,
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]
You are totally right!
"Harald Fuchs" <[EMAIL PROTECTED]> schreef in bericht
news:[EMAIL PROTECTED]
> In article <[EMAIL PROTECTED]>,
> "Timon Berkowitz" <[EMAIL PROTECTED]> writes:
>
> > Hi there,
> > Sorry for being a little bit confu
t2.nameofsoftware,
'') AS nameofsoftware
FROM Table1 t1 LEFT JOIN Table2 t2 ON t1.softid =
t2.softid
WHERE t1.nameofcd LIKE '%test%' OR t2.nameofsoftware LIKE
'%test%'
ORDER BY t1.softid, t1.nameofcd, t2.nameofsoftware
