周生产计划导出SQL语句

select  z.zdid as 站点编号,z.jhdhid as 计划单号编号,z.ddid as 订单ID,k.khmc as 客户名称,dd.ddhm as 订单号码,k.ddxh as 订单型号,ddmx.ddl as 订单量,ddmx.ddscl as 订单生产量,z.scrq as 备料日期,z.xll as 排产量,k.zsxs as 系数,z.wcrq as 完成日期,ddmx.ckg as 出口港 ,z.id as GuitarCodeCatalog from zscjhmx as z inner join dingdan as dd on z.ddid=dd.id inner join shengchanxian as s on z.scxid=s.id inner join dingdanmx as ddmx on ddmx.ddid = dd.id inner join khxh as k on z.khxh = k.ddxh and ddmx.khxh = k.id
where z.zdid = '6' and s.scxbh = '4' and z.scrq between '2008/04/14 0:00:00' and '2008/04/20 23:59:59'