在线请求您的帮助

[patriot_cool]

我想用一句话取出两个表结构完全相同的表A,B中的数据，条件也完全相同，请问这个sql怎么写呀？

[hdkkk]

SELECT * FROM (
SELECT A,B,C,D FROM A
UNION ALL
SELECT A,B,C,D FROM B)
WHERE A=.. AND B=..

[bzszp]

SELECT A,B,C,D FROM A where ...
UNION ALL
SELECT A,B,C,D FROM B where ...;

[vrv0129]

SELECT * FROM (
SELECT A,B,C,D FROM A
UNION ALL
SELECT A,B,C,D FROM B)
WHERE A=.. AND B=..