Is there a way to find all the unique rows across more than one tables? It's like stacking 2 tables and run this SELECT DISTINCT name FROM combinedTable

I tried
SELECT DISTINCT a.name FROM a,b,c,d.... but I think it just select those in table a only. What I'd like is across all tables.