pelegk1
12-04-2003, 08:33 AM
how do i join this 2 select's into 1
SELECT DISTINCT main_group FROM `products531` GROUP BY main_group
SELECT DISTINCT charact FROM `products531` WHERE main_group LIKE '%".$row['main_group']."%' GROUP BY charact
SELECT DISTINCT main_group FROM `products531` GROUP BY main_group
SELECT DISTINCT charact FROM `products531` WHERE main_group LIKE '%".$row['main_group']."%' GROUP BY charact