単純なSQLは大丈夫でした。
だめなのは、文字数？つかっている構文？

このSQLの登録です。店名、住所などは★マークに変えています。
日本郵便の送付状に流し込むためのCSV作成のSQLです。
ーーーーーーーーーーーーーーーーーーーーーーーーーーーー
s.order_id, o.status,
CASE
when o.payment_method = 'クレジットカード決済' then '0'
when o.payment_method = '代引決済' then '2'
END AS payment_method,
s.shipping_name01,s.shipping_name02,
s.shipping_kana01,s.shipping_kana02,
s.shipping_company_name,
s.shipping_tel01||'-'||s.shipping_tel02||'-'||s.shipping_tel03 as shipping_tel,
s.shipping_country_id, s.shipping_pref,
s.shipping_zip01||'-'||s.shipping_zip02 as shipping_zip,
s.shipping_zipcode,
s.shipping_addr01, s.shipping_addr02,time_id,
case
when s.time_id = '1' then '51'
when s.time_id = '2' then '52'
when s.time_id = '3' then '53'
when s.time_id = '4' then '54'
when s.time_id = '5' then '55'
when s.time_id = '6' then '56'
else '00'
end as shipping_time,
s.shipping_num, s.shipping_date,
s.shipping_commit_date,
o.payment_total,
case
when o.payment_method = 'クレジットカード決済' then '1100780'
when o.payment_method = '代引決済' then '1100747'
end as sheet_kind,
o.customer_id,o.create_date,o.update_date,o.order_kana01,o.order_kana02,
o.order_tel01||'-'||o.order_tel02||'-'||o.order_tel03 as order_tel,
case when s.gift_flag then o.order_name01 else '★★★★★★★★★' end as deliver_name01,
case when s.gift_flag then o.order_name02 else '' end as deliver_name02,
case when s.gift_flag then o.order_kana01 else '★★★★★★★★★★★★★★' end as deliver_kana01,
case when s.gift_flag then o.order_kana02 else '' end as deliver_kana02,
case when s.gift_flag then o.order_company_name else '' end as deliver_company_name,
case when s.gift_flag then concat(o.order_tel01,'-',o.order_tel02,'-',o.order_tel03) else '★★★★★★' end as deliver_tel,
case when s.gift_flag then o.order_country_id else '392' end as deliver_country_id,
case when s.gift_flag then o.order_pref else '13' end as deliver_pref,
case when s.gift_flag then concat(o.order_zip01,'-',o.order_zip02) else '★★★★' end as deliver_zip,
case when s.gift_flag then o.order_zipcode else '' end as deliver_zipcode,
case when s.gift_flag then o.order_addr01 else '北区赤羽西' end as deliver_addr01,
case when s.gift_flag then o.order_addr02 else '★★★' end as deliver_addr02
FROM dtb_shipping AS s INNER JOIN dtb_order AS o ON s.order_id = o.order_id
WHERE o.status = 9 and o.payment_method <> '店頭代金引換'
ーーーーーーーーーーーーーーーーーーーーーーーーーーーーーーーーーー