求一个查询语句

Question

有这样的两张表
配送点表（point_t）desc point_t
名称                             空值       类型                                                                                                                                                                                            
------------------------------ -------- --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- 
POI_ID                         NOT NULL NUMBER(20)    //配送点ID（PK）                                                                                                                                                                            
POI_NAME                       NOT NULL VARCHAR2(30)    //配送点名称                                                                                                                                                                          
POI_CITY                       NOT NULL VARCHAR2(30)                                                                                                                                                                                  
POI_PHONE                      NOT NULL VARCHAR2(20)                                                                                                                                                                                  
POI_ADDRESS                    NOT NULL VARCHAR2(100)  订单表
 （order_t）
desc order_t
名称                             空值       类型                                                                                                                                                                                            
------------------------------ -------- --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- 
ORD_ID                         NOT NULL NUMBER(20)     //订单ID                                                                                                                                                                             
ORD_STARTPOI_ID                         NUMBER(20)    //发货配送点ID（FK）                                                                                                                                                                                
ORD_ENDPOI_ID                           NUMBER(20)    // 收货配送点ID（FK）                                                                                                                                                                             
ORD_JOI_ID                              NUMBER(20)                                                                                                                                                                                    
ORD_USE_ID                              NUMBER(20)                                                                                                                                                                                    
ORD_GOODSNAME                  NOT NULL VARCHAR2(20)                                                                                                                                                                                  
ORD_RECEIVER                   NOT NULL VARCHAR2(30)                                                                                                                                                                                  
ORD_CITY                                VARCHAR2(200)                                                                                                                                                                                 
ORD_RECEIVEADDRESS             NOT NULL VARCHAR2(200)                                                                                                                                                                                 
ORD_RECEIVEPHONE               NOT NULL VARCHAR2(20)                                                                                                                                                                                  
ORD_SENDER                     NOT NULL VARCHAR2(30)                                                                                                                                                                                  
ORD_SENDADDRESS                NOT NULL VARCHAR2(200)                                                                                                                                                                                 
ORD_SENDPHONE                  NOT NULL VARCHAR2(20)                                                                                                                                                                                  
ORD_WEIGHT                     NOT NULL NUMBER       //货物重量                                                                                                                                                                                  
ORD_VOLUME                     NOT NULL NUMBER       //货物体积                                                                                                                                                                                 
ORD_TIME                       NOT NULL DATE                                                                                                                                                                                          
ORD_GOODSDESCRIBE              NOT NULL VARCHAR2(100)                                                                                                                                                                                 
ORD_STATUS                     NOT NULL VARCHAR2(10)                                                                                                                                                                                  
ORD_PRICE                      NOT NULL NUMBER                                                                                                                                                                                        
ORD_STATRTPRICE                         NUMBER                                                                                                                                                                                        
ORD_ENDPRICE                            NUMBER 我想在这俩表里  查出  
这样的结果配送点名  配送货物总体积  配送货物总质量  我就知道 配送货物总体积=收货总体积+发货总体积
          配送货物总质量=收货总质量+发货总质量
而且查询的时候要分组  别的我就不知道了  总之就是差不出来东西请高手知道  这个语句该怎么写？

Answer 1

select p.POI_NAME,sum(t.ORD_VOLUME),sum(t.ORD_WEIGHT)
from point_t p,order_t t
where p.POI_ID = t.ORD_STARTPOI_ID 
     or p.POI_ID = t.ORD_ENDPOI_ID
group by p.POI_NAME没测试   试一下·

Answer 2

这样行么,你试试
select 发货配送点,
POI_NAME 收货配送点,
ORD_VOLUME1=sum(发货总体积,ORD_VOLUME 配送货物总体积) ,
ORD_WEIGHT1=sum(发货总质量,ORD_WEIGHT 配送货物总质量)
from point_t a,order_t b,
(select POI_NAME 发货配送点,ORD_VOLUME 发货体积,ORD_WEIGHT 发货质量,   
 from point_t a,order_t b
 where b.ORD_STARTPOI_ID=a.POI_ID)
where b.ORD_ENDPOI_ID=a.POI_ID 
group by 发货配送点,收货配送点

Answer 3

哥  我在问个问题呗？ORD_TIME  是订单生成的时间 我想查从当前时间  到之前一个月的如上结果  该怎么写？

Answer 4

SELECT * from(select...) 
where CONVERT(VARCHAR(30),GETDATE(),112)-
to_number(to_char(ORD_TIME,'yyyymmdd'))=00600100