gistfile1.txt

use trio;
select commonCodeMaster.CommonCodeMasterId
	, commonCodeMaster.commoncodeDomainId
	, commonCodeMaster.code
	, commonCodeDomain.DomainName
	, commonCodeDetail.[Text]
	
 from 
commoncodemaster
inner join commoncodedomain on commoncodedomain.commoncodedomainid = commoncodemaster.commoncodedomainid
inner join commoncodedetail on commoncodemaster.commoncodemasterid = commoncodedetail.commoncodemasterid
inner join Country on CommonCodeDetail.CountryId = Country.CountryId
where country.Code = 'DK'
and commonCodeDomain.DomainName like N'%status%'
--and code = '020'
--and commoncodemaster.commoncodedomainid = 32
order by commoncodedomain.domainname
use master;