mysqlクエリ追加ヘッダ

1933 ワード

select '       ' as juan_orderno
		,'   '
		,'    '
		,'    '
		,'    '
		,'    '
		,'     '
)
union all
(
	select juan_orderno
		,juan_name
		,juan_phone
		,juan_price
		,juan_addtime
		,case_name
		,juan_remark
	from `juan`
	join `case` on juan_case_id=case_id
	where juan_status=1
)
order by juan_orderno desc