union all 两个查询语句结合查询

 SELECT
  a.item_code, b.mark,
  b. COMMENT,
  b.c_time collection_time
 FROM
  t_item a
 JOIN auc_watch_list b ON a.item_code = b.aid
 WHERE
  b.uid = '12345678911@gougoujp.com'
 
union all

SELECT
 a.aid as item_code,b.mark,b. COMMENT,
  b.c_time collection_time
FROM
 auc_watch_list b
JOIN auc_item a ON a.aid = b.aid
WHERE
 b.uid = '12345678911@gougoujp.com'


select a.aid,a.Title_cn,b.mark,b.comment ,b.c_time collection_time
    from auc_item a join auc_watch_list b on a.aid=b.aid 
    where b.uid = "12345678911@imaijp.com"

   
 union all
 select a.item_code as aid,a.item_name as Title_cn,b.mark,b.comment ,b.c_time collection_time
    from t_item a join auc_watch_list b on a.item_code=b.aid 
    where b.uid = "12345678911@imaijp.com"