+ 1
Are you asking how to do a Union on a query? if so here is an example
SELECT COUNTRY,LEAUGE,TEAM FROM SOCCER_INFO AS SI WITH (NOLOCK) WHERE COUNTRY = 'GERMANY'
UNION
SELECT COUNTRY,LEAUGE,TEAM FROM SOCCER_INFO AS SI WITH (NOLOCK) WHERE COUNTRY = 'ENGLAND '
note this is example query and is properly formatted but this is not an efficient query. the main thing to understand in a Union is that the column names have to be in the same order and MUST have the same name.