1.涉及两个字段组合成一个字段的concat函数,和case when判断字段是否为null
SELECT
c.ITEM,
c.SELECT_ID,
s.NAME,
( CASE WHEN c.TOP_NAME IS NULL THEN CONCAT( c.DISPLAY_NAME, s.NAME ) ELSE c.TOP_NAME END ) AS TOP_NAME
FROM
pdl_defined_criteria c,
pdl_product_type s
WHERE
s.ID = c.type_id
AND type_id = 20937
AND c.top_list_use = 1
AND c.item_id IS NOT NULL
ORDER BY
c.item_id DESC,
c.order_key;