900字范文 > php union用法 php编程SQL语句union all的使用编程

php union用法 php编程SQL语句union all的使用编程

时间：2018-08-09 04:54:17

起始时间

截止时间

c_huizong.php

if ($_POST['1shijian1']<>NULL)

$shijian1=" and COPTC.TC003>=".$_POST['1shijian1'];

else

$shijian1="";

if ($_POST['1shijian2']<>NULL)

$shijian2=" and COPTC.TC003<=".$_POST['1shijian2'];

else

$shijian2="";

require_once('i_code/connect.php');

$query="select leixing,xifen,sewen,ddgm,bztdb,daba,SUM(TD008) AS TD008,SUM(TA015)TA015,SUM(RKZS)RKZS,SUM(D310)D310,SUM(D305)D305,SUM(D304)D304,SUM(D3023)D3023,SUM(TH008)TH008,SUM(TJ007)TJ007

FROM chaxun

LEFT JOIN DDTJMX ON MA003=leixing and xifen=XIFEN AND sewen=DDTJMX.UDF10 AND ddgm=DDGM and daba=XINGHAO

left join COPTC on TC001=DDTJMX.TD001 AND TC002=DDTJMX.TD002

where xifen<>'' and xifen<>'5050' and TC003>='0110' AND TC003<='0120'

GROUP BY leixing,xifen,sewen,ddgm,bztdb,daba

union all

select leixing,xifen,null as sewen,null as ddgm,bztdb,null as daba,SUM(TD008) AS TD008,SUM(TA015)TA015,SUM(RKZS)RKZS,SUM(D310)D310,SUM(D305)D305,SUM(D304)D304,SUM(D3023)D3023,SUM(TH008)TH008,SUM(TJ007)TJ007

FROM chaxun

LEFT JOIN DDTJMX ON MA003=leixing and xifen=XIFEN

left join COPTC on TC001=DDTJMX.TD001 AND TC002=DDTJMX.TD002

where xifen='5050' and TC003>='0110' AND TC003<='0120'

GROUP BY leixing,xifen,bztdb

union all

select leixing,null as xifen,null as sewen,null as ddgm,bztdb, null as daba,SUM(TD008) AS TD008,SUM(TA015)TA015,SUM(RKZS)RKZS,SUM(D310)D310,SUM(D305)D305,SUM(D304)D304,SUM(D3023)D3023,SUM(TH008)TH008,SUM(TJ007)TJ007

FROM chaxun

LEFT JOIN DDTJMX ON MA003=leixing

left join COPTC on TC001=DDTJMX.TD001 AND TC002=DDTJMX.TD002

where xifen='' and TC003>='0110' AND TC003<='0120'

GROUP BY leixing,bztdb".$shijian1.$shijian2;

$result=mssql_query($query);

$row_num=mssql_num_rows($result);

if ($row_num<=10000 && $row_num>0)

{

echo "

echo "类别;

细分;