insert into YP_YPCJD(N_YPLX,N_YPZLX,S_YPPM,S_YPJX,S_YPSPM,S_YPGG,S_SCCJ,S_YPDW,SCCJ)
SELECT y.YPLX,y.YPZLX,y.YPPM,y.YPJX,y.YPSPM,y.YPGG,y.SCCJ,y.S_YPDW,sc.id,YPDW
FROM YAOPING as y
INNER JOIN yp_SCJJ AS sc on y.sccj=sc.sccj
S_SCCJ为VARCHAR SCCJ为INT SCCJ对应YP_SCCJ
我要同时添加进YP_YPCJD怎么做
另外以S_YPPM 为条件该怎么排序 如果相同那么ID为同一个!
SELECT y.YPLX,y.YPZLX,y.YPPM,y.YPJX,y.YPSPM,y.YPGG,y.SCCJ,y.S_YPDW,sc.id,YPDW
FROM YAOPING as y
INNER JOIN yp_SCJJ AS sc on y.sccj=sc.sccj
S_SCCJ为VARCHAR SCCJ为INT SCCJ对应YP_SCCJ
我要同时添加进YP_YPCJD怎么做
另外以S_YPPM 为条件该怎么排序 如果相同那么ID为同一个!
order by.....
SELECT y.YPLX,y.YPZLX,y.YPPM,y.YPJX,y.YPSPM,y.YPGG,LTRIM(y.SCCJ),y.S_YPDW,sc.id,YPDW
FROM YAOPING as y
INNER JOIN yp_SCJJ AS sc on y.sccj=sc.sccj
???
需要把SCCJ和S_SCCJ同时添加到YP_YPCJD里面去!
但是SCCJ为INT S_SCCJ为VARCHAR SCCJ要转换!
insert into
YP_YPCJD(N_YPLX,N_YPZLX,S_YPPM,S_YPJX,S_YPSPM,S_YPGG,S_SCCJ,S_YPDW,SCCJ)
SELECT
y.YPLX,y.YPZLX,y.YPPM,y.YPJX,y.YPSPM,y.YPGG,LTRIM(y.SCCJ),y.S_YPDW,YPDW
FROM
YAOPING as y , yp_SCJJ AS sc
where
y.sccj=sc.sccj
order by
S_YPPM
declare @t table(id int ,data1 int,data2 int)
declare @t1 table(id int,data1 int)
declare @t2 table(id int,data2 int)insert into @t1
select 2,2
union all select 3,3
union all select 1,1insert into @t2
select 2,22
union all select 3,33
union all select 1,11insert into @t
select a.id,data1,data2
from @t1 a inner join @t2 b on a.id = b.id order by a.idselect * from @t
id data1 data2
----------- ----------- -----------
1 1 11
2 2 22
3 3 33
SCCJ 这个是取yp_SCJJ对应的ID啊!
不是把他转换成整形就行 !
SCCJ 这个是取yp_SCJJ对应的ID啊!
S_SCCJ为VARCHAR SCCJ为INT SCCJ对应YP_SCCJ 我要同时添加进YP_YPCJD怎么做
FROM YAOPING as y
INNER JOIN yp_SCJJ AS sc on y.sccj=sc.sccj UNION ALLSELECT y.YPLX,y.YPZLX,y.YPPM,y.YPJX,y.YPSPM,y.YPGG,SC.SCCJ,y.S_YPDW,sc.id,YPDW
FROM YAOPING as y
INNER JOIN yp_SCJJ AS sc on y.sccj=sc.sccj 楼主是这意思??
insert into YP_YPCJD(N_YPLX,N_YPZLX,S_YPPM,S_YPJX,S_YPSPM,S_YPGG,S_SCCJ,S_YPDW,SCCJ)
SELECT y.YPLX,y.YPZLX,y.YPPM,y.YPJX,y.YPSPM,y.YPGG,y.SCCJ,y.YPDW,sc.id
FROM yaoping as y
INNER JOIN yp_SCCJ AS sc on y.sccj=sc.sccj
where y.sccj not in (select s_SCCJ from YP_YPCJD)
and y.yppm not in(select S_yppm from yp_ypcjd) 这才是我的意思!