create view S_ZJPLJH_VIEW as
select S_ZJPLJH.*,S_TDYLFB_CT.NZX
from S_ZJPLJH,S_TDYL_CT,S_TDYLFB_CT,S_ZXJ
where
S_ZJPLJH.CCC = S_TDYL_CT.CCC and
S_TDYL_CT.CYLDM = S_TDYLFB_CT.CYLDM and
S_ZJPLJH.CFYJ = S_ZXJ.CZXJMC and
S_ZXJ.CZXJDM = S_TDYLFB_CT.CJDM
group by S_ZJPLJH.CCC,S_TDYLFB_CT.NZX,S_ZJPLJH.CFYJ,
S_ZJPLJH.CFYJSSS,S_ZJPLJH.NMZBZ,S_ZJPLJH.NZZFL,S_ZJPLJH.CZJXFQD,
S_ZJPLJH.NZJXFL,S_ZJPLJH.CBZPFQD,S_ZJPLJH.NBZPFXL,S_ZJPLJH.CSJXGJY,
S_ZJPLJH.CBZ,S_ZJPLJH.NXLH;
我需要按s_zjpljh.CCC,和S_TDYLFB_ct.nzx排序,但group by不行
并没有按nzx排序,该怎么写sql?
|