Seeking SQL summary statement.. Master please help us to see

zxmsgdhr

Table a
clbm,clmc
1 a
2 b
3 c


Table b
clbma,clmca,clgg, jj, sj, flbm
545 a1 re 8.0 8.0 1
434 a2 re 15.2 8.0 1
676 a3 re 9.0 8.0 1
21 b4 re 9.0 8.0 2
54 b1 re 9.0 8.0 2
67 b2 as 9.0 8.0 2
54 c1 d 9.0 8.0 3
23 c2 vc 9.0 8.0 3
5 c3 fd 9.0 8.0 3
54 c4 fd 9.0 8.0 3


The result to be obtained:
1 a
545 a1 re 8.0 8.0 1
434 a2 re 15.2 8.0 1
676 a3 re 9.0 8.0 1
2 b
21 b4 re 9.0 8.0 2
54 b1 re 9.0 8.0 2
67 b2 as 9.0 8.0 2
3 c
54 c1 d 9.0 8.0 3
23 c2 vc 9.0 8.0 3
5 c3 fd 9.0 8.0 3
54 c4 fd 9.0 8.0 3

我是杀人狂

select * from(select clbm as clbma,clmc as clmca,clgg='', jj='', sj='', flbm='' from table1
union all
select * from table2)a
order by clmca

wgfxman

Use FULL JOIN to sort according to the second field

wgfxman

I've mispoken. . ~-!
, UNION ALL

zxmsgdhr

jj and sj fields are money type

wgfxman

select * from(select clbm as clbma,clmc as clmca,clgg=NULL, jj=NULL, sj=NULL, flbm=NULL from table1
union all
select * from table2)a
order by clmca

gosh. .

zxmsgdhr

select * from(select clbm as clbma,clmc as clmca,clgg=``, jj='', sj='', flbm='' from gdyj.pubcwcl
union all
select clbma,clmca,clgg,cast(jj as char),cast(sj as char),flbm from dda)a order by clmca

Is not the desired result

zxmsgdhr

Can't sort by clmca field. It will be messy.

wgfxman

select clbma,clmc,clmca,clgg, jj, sj, flbm from(select clbm as clbma,clmc as clmc,'' as clmca,clgg=NULL, jj=NULL, sj=NULL, flbm=NULL,0 as ord from table1
union all
select clbma,'',clmca,clgg, jj, sj, flbm,1 as ord from table2)a
order by ord,clmca

peng16889

I can't sort it yet, I'm very depressed