select p.paramid, p.paramname, p.paramdescription, c.websiteid, c.paramvalue from tbl_CUS_WebSiteParameters p left outer join tbl_CUS_WebSiteConfigurations c on c.paramid = p.paramid and c.websiteid = order by paramname, paramDescription;