Ver originalSELECT sbc.* FROM(SELECT * FROM productos p INNER JOIN categoria c ON p.id_categoria=c.id_categoria WHERE c.id_categoria=XUNIONSELECT * FROM productos p INNER JOIN categoria c ON p.id_categoria=c.id_categoria WHERE c.IdPadre=X) sbcORDER BY sbc.NOMBRECampo;