请教，SQL-92标准和SQL-99写法的差别
请教，SQL-92标准和SQL-99写法的差别
日期：2021-07-15 03:18:39 人气：1
QL>select /* index(h I_ic_general_h_2) */
2 invcl.invclassname,round((avg(b.nprice)/0.854),2) price
3 from ic_general_b b
4 inner join ic_general_h h on h.cgeneralhid=b.cgeneralhid
5 inner join bd_invbasdoc
2 invcl.invclassname,round((avg(b.nprice)/0.854),2) price
3 from ic_general_b b
4 inner join ic_general_h h on h.cgeneralhid=b.cgeneralhid
5 inner join bd_invbasdoc