Please help me see what went wrong? Message 207, Level 16, State 3, Invalid column name 'je'

恶魔右指

Run separately and see if there is an error, not necessarily this statement

loverabbit

Change to
create view v_all
as

select wzlb = left (wzdm, 2),
rkje = sum (je),
ckje = 0,
fsrq = rksj,
kcje = 0
from materials and materials
group by left (wzdm, 2), rksj

If you execute the above code alone, there is no problem.

恶魔右指

RKSJ DATETIME 8 No Storage time
DATETIME used this column grouping, sum still makes sense ???
If the column is (2006-01-01 11:25:00 120), it doesn't make sense.

loverabbit

Material code is AABBCCDDDD
The first sentence wzlb = left (wzdm, 2) is the largest class of materials AA, and the finest classification code AABBCCDDDD is stored in wzdm.
If you use datetime grouping, isn't the sum of all the major types of supplies the day after sum?

If group by removes rksj, the error message after execution is
Server: Msg 8120, Level 16, State 1, Line 1
The column 'Material material in storage.rksj' is invalid in the select list because it is neither included in the aggregation function nor in the GROUP BY clause.

If you don't group by rksj, do you use having?

loverabbit

Tried with max (rksj) and the results came out
create view v_all
as

select wzlb = left (wzdm, 2),
rkje = sum (je),
ckje = 0,
fsrq = max (rksj),
kcje = 0
from materials and materials
group by left (wzdm, 2)

There is no problem with this paragraph. Continue to try the next paragraph. Thank you so much.