Do a customer supplies the summary table for given a time, a month, or day, query all customer or single material flow every day; Different points in time customers; Different materials; Different flow;

Try to sit in the ireport statistical results cannot be effective nested multiple conditions at the same time,

Help is ireport use error; Or only the SQL statement;

SQL statements can't write
Now the SQL statement

 
The select weight. Minecode minecode, 
Substr (weight. Grosstime, 0, 10) qgrosstime, 
Arthur c. ustname custname, 
V.v name vname, 
PC. The name custarea, 
Weight. Zprice zprice, 
Weight. Grossweight grossweight, 
Weight. Tareweight tareweight, 
Weight.net weight netweight, 
Substr (weight. Grosstime, 0, 10) grosstime 
The from 
(select w.m inecode minecode, 
W.c ustno custno, 
W.v arno varno, w.g rosstime grosstime, 
S.c ustarea custarea, 
NVL (w.net weight, 0) * NVL (s. reightprice, 0) zprice, 
NVL (w.g rossweight, 0) grossweight, 
NVL (w.t areweight, 0) tareweight, 
NVL (w.net weight, 0) netweight 
The from sale_weight w, sale_notice s 
Where w.m inecode=s.m inecode (+) 
And w.n oticeno=s.n oticeno (+) 
And w.w eightflag='1' 
And w.m inecode='7025' and w.g rosstime> 00:00:00='2018-09-01' and w.g rosstime<23:59:59='2018-09-18') weight, 
Cust_custinfo c, pub_vardict v, pub_custarea PC 
Where weight. Custno=Arthur c. ustno (+) 
And weight. Varno=v.v code (+) 
And weight. Custarea=PC. Id (+) 
The order by substr (weight. Grosstime, 0, 10), Arthur c. ustname, v.v name, PC. Name 

Try reply downstairs to upload picture uploading failure

CodePudding user response:

CodePudding user response:

CodePudding user response:

This kind of circumstance I suggest to do, from a view or grammar too long it is easy to make a mistake

CodePudding user response:

With a GROUP BY
GROUP BY customers, supplies, flow

CodePudding user response:

You make a list table structure, involving what tables, relationships between tables, I can give you write, I want the 100 points, lack of integral download ah