List all Tab

SELECT TC.TABCONTROLNO, C.CRITERIANO, C.CASEOFFICEID, O.DESCRIPTION AS OFFICE, CT.CASETYPE, CT.CASETYPEDESC, PT.PROPERTYTYPE, PT.PROPERTYNAME, CTY1.COUNTRYCODE, CTY1.COUNTRY, CTY2.COUNTRY AS VALIDCOUNTRY, CC.CASECATEGORY, CC.CASECATEGORYDESC, ISNULL(VC1.CASECATEGORYDESC, VC2.CASECATEGORYDESC) AS VALIDCASECATEGORYDESC,
       C.PROGRAMID, C.PROPERTYTYPE, C.PROPERTYUNKNOWN, C.COUNTRYCODE, C.COUNTRYUNKNOWN, C.CASECATEGORY, C.CATEGORYUNKNOWN, WC.WINDOWCONTROLNO, WC.WINDOWNAME, WC.ISEXTERNAL, TC.TABCONTROLNO, TC.TABNAME, TC.DISPLAYSEQUENCE, TC.TABTITLE
FROM CRITERIA C JOIN WINDOWCONTROL WC ON C.CRITERIANO = WC.CRITERIANO
LEFT JOIN TABCONTROL TC ON WC.WINDOWCONTROLNO = TC.WINDOWCONTROLNO
LEFT JOIN OFFICE O ON C.CASEOFFICEID = O.OFFICEID
LEFT JOIN CASETYPE CT ON C.CASETYPE = CT.CASETYPE
LEFT JOIN PROPERTYTYPE PT ON C.PROPERTYTYPE = PT.PROPERTYTYPE
LEFT JOIN CASECATEGORY CC ON CC.CASETYPE = C.CASETYPE AND CC.CASECATEGORY = C.CASECATEGORY
LEFT JOIN COUNTRY CTY1 ON C.COUNTRYCODE = CTY1.COUNTRYCODE
LEFT JOIN VALIDCATEGORY VC1 ON VC1.CASETYPE = C.CASETYPE AND VC1.PROPERTYTYPE = C.PROPERTYTYPE AND VC1.CASECATEGORY = C.CASECATEGORY AND VC1.COUNTRYCODE = C.COUNTRYCODE
LEFT JOIN VALIDCATEGORY VC2 ON VC2.CASETYPE = C.CASETYPE AND VC2.PROPERTYTYPE = C.PROPERTYTYPE AND VC2.CASECATEGORY = C.CASECATEGORY AND VC2.COUNTRYCODE = 'ZZZ'
LEFT JOIN COUNTRY CTY2 ON CTY2.COUNTRYCODE = ISNULL(VC1.COUNTRYCODE, VC2.COUNTRYCODE)
WHERE TABTITLE LIKE '%Case Billing info%'
ORDER BY C.CRITERIANO, TC.DISPLAYSEQUENCE