[venami]

Your SQL should look like this:

SELECT t.name FROM trace t, trans c WHERE (t.name = 'name1' or t.name =  'name 3' or t.name = 'name4' or t.name = 'name5') AND t.id=c.id;

or like this:

SELECT t.name FROM trace t, trans c WHERE t.name in ('name1', 'name 3', 'name4', 'name5') AND t.id=c.id;