SQL 语句

SELECT DISTINCT
	T1.BRANDNAME,
	T1.DESCRIPTION,
	T1.FIELD1,
	T2.FIELD1
FROM
	IT_T_BRAND_FIELD T1,
	IT_T_BRAND_PARAMETER T2
WHERE
	T1.DESCRIPTION = T2.SERIES
AND T1.BRANDNAME = T2.BRANDNAME and T2.FIELD1 is not null
UNION
SELECT DISTINCT
	T1.BRANDNAME,
	T1.DESCRIPTION,
	T1.FIELD2,
	T2.FIELD2
FROM
	IT_T_BRAND_FIELD T1,
	IT_T_BRAND_PARAMETER T2
WHERE
	T1.DESCRIPTION = T2.SERIES
AND T1.BRANDNAME = T2.BRANDNAME and T2.FIELD2 is not null UNION
SELECT DISTINCT
	T1.BRANDNAME,
	T1.DESCRIPTION,
	T1.FIELD3,
	T2.FIELD3
FROM
	IT_T_BRAND_FIELD T1,
	IT_T_BRAND_PARAMETER T2
WHERE
	T1.DESCRIPTION = T2.SERIES
AND T1.BRANDNAME = T2.BRANDNAME and T2.FIELD3 is not null
UNION
SELECT DISTINCT
	T1.BRANDNAME,
	T1.DESCRIPTION,
	T1.FIELD4,
	T2.FIELD4
FROM
	IT_T_BRAND_FIELD T1,
	IT_T_BRAND_PARAMETER T2
WHERE
	T1.DESCRIPTION = T2.SERIES
AND T1.BRANDNAME = T2.BRANDNAME and T2.FIELD4 is not null
UNION
SELECT DISTINCT
	T1.BRANDNAME,
	T1.DESCRIPTION,
	T1.FIELD5,
	T2.FIELD5
FROM
	IT_T_BRAND_FIELD T1,
	IT_T_BRAND_PARAMETER T2
WHERE
	T1.DESCRIPTION = T2.SERIES
AND T1.BRANDNAME = T2.BRANDNAME and T2.FIELD5 is not null
UNION
SELECT DISTINCT
	T1.BRANDNAME,
	T1.DESCRIPTION,
	T1.FIELD6,
	T2.FIELD6
FROM
	IT_T_BRAND_FIELD T1,
	IT_T_BRAND_PARAMETER T2
WHERE
	T1.DESCRIPTION = T2.SERIES
AND T1.BRANDNAME = T2.BRANDNAME and T2.FIELD6 is not null
UNION
SELECT DISTINCT
	T1.BRANDNAME,
	T1.DESCRIPTION,
	T1.FIELD7,
	T2.FIELD7
FROM
	IT_T_BRAND_FIELD T1,
	IT_T_BRAND_PARAMETER T2
WHERE
	T1.DESCRIPTION = T2.SERIES
AND T1.BRANDNAME = T2.BRANDNAME and T2.FIELD7 is not null
UNION
SELECT DISTINCT
	T1.BRANDNAME,
	T1.DESCRIPTION,
	T1.FIELD8,
	T2.FIELD8
FROM
	IT_T_BRAND_FIELD T1,
	IT_T_BRAND_PARAMETER T2
WHERE
	T1.DESCRIPTION = T2.SERIES
AND T1.BRANDNAME = T2.BRANDNAME and T2.FIELD8 is not null
UNION
SELECT DISTINCT
	T1.BRANDNAME,
	T1.DESCRIPTION,
	T1.FIELD9,
	T2.FIELD9
FROM
	IT_T_BRAND_FIELD T1,
	IT_T_BRAND_PARAMETER T2
WHERE
	T1.DESCRIPTION = T2.SERIES
AND T1.BRANDNAME = T2.BRANDNAME and T2.FIELD9 is not null
UNION
SELECT DISTINCT
	T1.BRANDNAME,
	T1.DESCRIPTION,
	T1.FIELD10,
	T2.FIELD10
FROM
	IT_T_BRAND_FIELD T1,
	IT_T_BRAND_PARAMETER T2
WHERE
	T1.DESCRIPTION = T2.SERIES
AND T1.BRANDNAME = T2.BRANDNAME and T2.FIELD10 is not null
UNION
SELECT DISTINCT
	T1.BRANDNAME,
	T1.DESCRIPTION,
	T1.FIELD11,
	T2.FIELD11
FROM
	IT_T_BRAND_FIELD T1,
	IT_T_BRAND_PARAMETER T2
WHERE
	T1.DESCRIPTION = T2.SERIES
AND T1.BRANDNAME = T2.BRANDNAME and T2.FIELD11 is not null
UNION
SELECT DISTINCT
	T1.BRANDNAME,
	T1.DESCRIPTION,
	T1.FIELD12,
	T2.FIELD12
FROM
	IT_T_BRAND_FIELD T1,
	IT_T_BRAND_PARAMETER T2
WHERE
	T1.DESCRIPTION = T2.SERIES
AND T1.BRANDNAME = T2.BRANDNAME and T2.FIELD12 is not null
UNION
SELECT DISTINCT
	T1.BRANDNAME,
	T1.DESCRIPTION,
	T1.FIELD13,
	T2.FIELD13
FROM
	IT_T_BRAND_FIELD T1,
	IT_T_BRAND_PARAMETER T2
WHERE
	T1.DESCRIPTION = T2.SERIES
AND T1.BRANDNAME = T2.BRANDNAME and T2.FIELD13 is not null
UNION
SELECT DISTINCT
	T1.BRANDNAME,
	T1.DESCRIPTION,
	T1.FIELD14,
	T2.FIELD14
FROM
	IT_T_BRAND_FIELD T1,
	IT_T_BRAND_PARAMETER T2
WHERE
	T1.DESCRIPTION = T2.SERIES
AND T1.BRANDNAME = T2.BRANDNAME and T2.FIELD14 is not null
UNION
SELECT DISTINCT
	T1.BRANDNAME,
	T1.DESCRIPTION,
	T1.FIELD15,
	T2.FIELD15
FROM
	IT_T_BRAND_FIELD T1,
	IT_T_BRAND_PARAMETER T2
WHERE
	T1.DESCRIPTION = T2.SERIES
AND T1.BRANDNAME = T2.BRANDNAME and T2.FIELD15 is not null
UNION
SELECT DISTINCT
	T1.BRANDNAME,
	T1.DESCRIPTION,
	T1.FIELD16,
	T2.FIELD16
FROM
	IT_T_BRAND_FIELD T1,
	IT_T_BRAND_PARAMETER T2
WHERE
	T1.DESCRIPTION = T2.SERIES
AND T1.BRANDNAME = T2.BRANDNAME and T2.FIELD16 is not null
UNION
SELECT DISTINCT
	T1.BRANDNAME,
	T1.DESCRIPTION,
	T1.FIELD17,
	T2.FIELD17
FROM
	IT_T_BRAND_FIELD T1,
	IT_T_BRAND_PARAMETER T2
WHERE
	T1.DESCRIPTION = T2.SERIES
AND T1.BRANDNAME = T2.BRANDNAME and T2.FIELD17 is not null