SELECT * FROM TABLE1 WHERE EXISTS (SELECT 1 FROM TABLE4 WHERE TABLE4.NAME = TABLE1.NAME)
UNION
SELECT * FROM TABLE2 WHERE EXISTS (SELECT 1 FROM TABLE4 WHERE TABLE4.NAME = TABLE2.NAME)
UNION
SELECT * FROM TABLE2 WHERE EXISTS (SELECT 1 FROM TABLE4 WHERE TABLE4.NAME = TABLE2.NAME)
呵呵,不好意思,让你误会了。这四个表我之列出了部分字段