試試看VLOOKUP可不可以解決你的問題
使用union all SELECT 'uncancel' status,s.icon FROM `stock` as s JOIN `order` as o...