34,588
社区成员
发帖
与我相关
我的任务
分享
select table2.item_id
from table2 left join (
select item_id
from table1,table3
where table1.mission_id=table3.mission_id
and table1.player_id=1) t on table2.item_id=t.item_id
where t.item_id is null
declare @a int,@b int
set @a=32
set @b=28
select @a-@b
/*
-----------
4
*/
declare @a decimal(10,5),@b decimal (10,5)
set @a=12.5423
set @b=1.5421
select @a-@b
/*
11.00020
*/