SQLはじめて試行錯誤でこうなった。

--------------------------------------------------------------------------------------

dtb_shipping.create_date as "受付日",
concat(dtb_order.order_name01 , ' ' , dtb_order.order_name02) as "注文者氏名",
concat(dtb_order.order_kana01 , ' ' , dtb_order.order_kana02) as "注文者注文者カナ",
dtb_order.order_sex as "注文者性別",
concat(dtb_order.order_tel01 , '-' , dtb_order.order_tel02 , '-' , dtb_order.order_tel03) as "注文者電話番号",
dtb_order.order_birth as "注文者生年月日",
concat(dtb_order.order_zip01 , '-' , dtb_order.order_zip02) as "注文者郵便番号",
concat(dtb_order.order_pref,dtb_order.order_addr01) as "注文者住所1",
dtb_order.order_addr02 as "注文者住所2",
dtb_order.deliv_fee as "送料",
dtb_order.payment_method as "支払方法",
dtb_order_detail.quantity as "商品数",
concat(dtb_shipping.shipping_name01 , ' ' , dtb_shipping.shipping_name02) as "配送先名",
concat(dtb_shipping.shipping_kana01 , ' ' , dtb_shipping.shipping_kana02) as "配送先名フリガナ",
concat(dtb_shipping.shipping_tel01 , '-' , dtb_shipping.shipping_tel02 , '-' , shipping_tel03) as "配送先電話番号",
concat(dtb_shipping.shipping_zip01 , '-' , dtb_shipping.shipping_zip02) as "配送先郵便番号",
concat(dtb_shipping.shipping_pref,dtb_shipping.shipping_addr01) as "配送先住所1",
dtb_shipping.shipping_addr02 as "配送先住所2",
dtb_order_detail.product_name as "商品名"

FROM
dtb_shipping,dtb_order,dtb_order_detail

WHERE
dtb_order.order_id=dtb_shipping.order_id
AND
dtb_order.order_id=dtb_order_detail.order_id

--------------------------------------------------------------------------------------

一応これで注文者情報と配送先の情報と注文内容が把握できるかな