UNION ALL 後的有有法？
比如

select * from (select * from 正常表) a
union all (select * from 常表) b
where ...
上就示

ID 品 品名 ... 操作
1 AB001 AB系列 除
2 AC001 AC系列 除
3 AF001 AF系列 除
4 AT001 AT系列 除

正常表和常表就示在一起
那按除的候，怎能自找到正常表或常表而除呢？

[解决办法]
要不加一个标识

select * from (select *, '正常表 ' as [标识] from 正常表) a
union all (select *, '常表 ' as [标识] from 常表) b
where ...

[解决办法]
please write in english or pinying