关于红字能够比较出数据的原理是啥??
不太清楚!请教一下!select distinct
b.gyomuno,
b.gyomudatetime,
b.gyomujanm,
b.gyomumemo,
'shisanno' as keyname,
a.shisanno as keyvalue
from
PHShisanDB.dbo.Tochirireki a
inner join
PHShisanDB.dbo.Gyomu b
on
a.gyomuno = b.gyomuno
and
b.deleteflag = '0'
where
a.shisanno = @shisanno
and
a.rirekino< 'BR0000014'
order by b.gyomuno desc
不太清楚!请教一下!select distinct
b.gyomuno,
b.gyomudatetime,
b.gyomujanm,
b.gyomumemo,
'shisanno' as keyname,
a.shisanno as keyvalue
from
PHShisanDB.dbo.Tochirireki a
inner join
PHShisanDB.dbo.Gyomu b
on
a.gyomuno = b.gyomuno
and
b.deleteflag = '0'
where
a.shisanno = @shisanno
and
a.rirekino< 'BR0000014'
order by b.gyomuno desc
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货