What I ment is this :-) Table1 consists out of the following fields and data +------+----------------+ | softid | nameofcd | +------+----------------+ | 1 | test cd 1 | | 2 | software cd 2 | | 3 | software cd 3 | | 4 | test cd 2 | +------+----------------+
Table2 consists out of the following fields and data +----+--------+----------------+ | id | softid | nameofsoftware | +----+--------+----------------+ | 1 | 1 | test software | | 2 | 1 | software 1 | | 3 | 1 | software 2 | | 4 | 2 | software 3 | | 5 | 2 | software 4 | +----+--------+----------------+ The output I need is the following +--------+----------------+----------------+ | softid | nameofcd | nameofsoftware | +--------+----------------+----------------+ | 1 | test cd 1 | | | 1 | test cd 1 | test software | | 4 | test cd 2 | | +--------+----------------+----------------+ So that will require the following criteria when using the string 'test': - Show all records where nameofcd which contain the string test AND - Show all records where nameofcd which contain the string test AND - Do not show any duplicates of the combination and nameofcd and nameofsoftware That means do no show the others, how obvious! 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]