SELECT(select CONCAT(BrndName,' - ',ModName,' - ',Capacity) from details where Devname='PROCESSOR' ) as Processor,
(select CONCAT(BrndName,' - ',ModName,' - ',Capacity) from details where Devname='PROCESSOR' ) as Memo
ub_autocomplete ON ub_meta.autocomplete_id=ub_autocomplete.id 得到这样的结果:注意,列、level_two、和-they应该在同一列中。因此,本质上,我需要将这两列的结果合并到一列中(结果集中将产生更多行)。任何建议,指出我的正确方向,将不胜感激。