Re-analysis of open, close, high, and low prices

//Maximum ValueSelect Max(Price)Max, date fromOn_jiaoyi_intoGroup  byDate//Minimum ValueSelect min(Price)min, date fromOn_jiaoyi_intoGroup  byDate//Open PriceSelectA.price,a.date from (SelectPrice,date fromOn_jiaoyi_intowhereSid=3Order  bydate,time) AGroup  byDate//closing priceSelectA.price,a.date from (SelectPrice,date fromOn_jiaoyi_intowhereSid=3Order  byDate,timedesc) AGroup  byDateSelectZdz.Max, Zxz.min, KPJ.KPJ,SPJ.SPJ from (/*Maximum Value*/Select Max(Price)Max, Date,id fromOn_jiaoyi_intoGroup  bydate) Zdz Left Join (/*Minimum Value*/Select min(Price)min, Date,id fromOn_jiaoyi_intoGroup  bydate) Zxz onZdz.id=zxz.id Left Join(/*Open Price*/SelectA.price kpj,a.date,a.id from(SelectPrice,date,id fromOn_jiaoyi_intowhereSid=3 Order  byDate,time) AGroup  bydate) KPJ onZdz.id=kpj.id Left Join(/*closing price*/SelectB.price spj,b.date,b.id from(SelectPrice,date,id fromOn_jiaoyi_intowhereSid=3 Order  byDate,timedesc) bGroup  bydate) SPJ onZdz.id=Spj.id

The result of the last join is that a field is null, and finally think about it, because their maximum, minimum, open, close price may not be an ID ....

Then, only the result of the above four query results with the method of merging arrays is correct ...

Re-analysis of open, close, high, and low prices