problema com union

[Ratu 0]

SELECT DISTINCT nome,email FROM(SELECT nome, email FROM app_psc_visitante WITH(NOLOCK)UNIONSELECT nome, email FROM app_bfs_visitante WITH(NOLOCK)UNIONSELECT nome, email FROM app_sbf_visitante WITH(NOLOCK))dá este erro!Server: Msg 170, Level 15, State 1, Line 15Line 15: Incorrect syntax near ')'.pq?

[eriva_br 7]

pelo 1º select --> SELECT DISTINCT nome,email FROM tenta coloca tudo numa tabela virtual e depois fazer o distinct

[Ratu 0]

CONSEGUI! SELECT nome, email FROM app_psc_visitante WITH(NOLOCK) where email like 'thiagoananias@hotmail.com' UNION SELECT nome, email FROM app_bfs_visitante WITH(NOLOCK) where email like 'thiagoananias@hotmail.com' UNION SELECT nome, email FROM app_sbf_visitante WITH(NOLOCK) where email like 'thiagoananias@hotmail.com'VALEU eriva br