Query with the union

Question

How to make it work?

$sql4 = "SELECT * FROM prodtype_light WHERE pcode like '(UNION SELECT prodtype FROM prodvendor_light WHERE id = 1)%'";

angry

5,855 15 56 171

Denis_Zuew

6 one

|

1 answer 1

msi msi 11k eleven sixteen · Answer 1 · 2012-02-01T16:55:28

 SELECT * FROM prodtype_light WHERE pcode like (SELECT prodtype+'%' FROM prodvendor_light WHERE id = 1)