Código :
mysql> select t2.TID, t2.title As Stitle, t1.DID, t1.title from rpvcms_sections As t2, rpvcms_data As t1 WHERE (t2.sext LIKE 'G' AND t2.sextA IS NOT NULL) -> AND (t1.sextB=t2.TID) group by t1.sextB ORDER BY t1.DID DESC, t2.title AS C; +-----+------------+-----+-----------+ | TID | Stitle | DID | title | +-----+------------+-----+-----------+ | 20 | Mujeres | 182 | M_TITULO: | | 19 | Hombres | 181 | H_TITULO: | | 18 | Amigos(as) | 179 | NULL | +-----+------------+-----+-----------+ 3 rows in set (0.02 sec)
bueno a ver quien lo resuelve primero, ya yo tengo la solución
no lo movais a charla aún. dejad que se partan el coco un rato.