+ 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.
25th Jun 2016, 4:22 PM
Stevan Camp