sql合并去重查询练习 By yusijia September 04 2016 Updated:September 04 2016 Contents 123456# 自动去重SELECT id FROM t_book UNION SELECT id FROM t_booktype;# 不去重SELECT id FROM t_book UNION ALL SELECT id FROM t_booktype;