select a.ID,a.name,sex,b.ID,b.name,old from A full join B on a.ID=b,ID order by a.ID;
按下列方式试试。
select a.ID,a.name,sex,b.ID,b.name,old from A full join B on a.ID=b,ID
where (a.name is null and a.sex is null and b.name is not null) or
(a.name is not null and a.sex is not null and b.name is null)
order by a.ID;
declare @strsql nvarchar(1024),@ID int
set @strsql=''
if(@ID=3)
begin
select * from A
end
else if(@ID=4)
begin
select * from B
end
exec(@strsql)
不知道这样算不算一句
内容全部来源于网络收集，如有侵权，请联系网站删除：QQ号：24596024