SELECT * FROM uno WHERE campo = 1 UNION ALL SELECT * FROM dos WHERE campo = 1 UNION ALL SELECT * FROM tres WHERE campo = 1