错误1:select a,b,c from t1 union all select a,b,c from t2;
错误2:select a,b,c from t1 union all select a,c,b from t2;
错误原因:
1.t1表和t2表的abc字段中存在某个字段的类型不一致,如时间一个是date类型,一个是varchar类型;
2.t1表和t2表的abc字段类型全部一致,但是查询abc三个字段的顺序不一致;
错误1:select a,b,c from t1 union all select a,b,c from t2;
错误2:select a,b,c from t1 union all select a,c,b from t2;
错误原因:
1.t1表和t2表的abc字段中存在某个字段的类型不一致,如时间一个是date类型,一个是varchar类型;
2.t1表和t2表的abc字段类型全部一致,但是查询abc三个字段的顺序不一致;