--05
select id,value from a
except
select uid,value from b

-----or

select *
from a t
where not exists (select 1 from b where uid = t.id or value = t.value)

------解决方案--------------------
SQL code

select A.* from A
inner join B on A.Id<>B.UId and A.Value <> B.Value

------解决方案--------------------
SQL code
select
 *
from
 a
where
 not exists (select 1 from b where uid = a.id or value = a.value)

------解决方案--------------------

select * from A where not exists(  
A.ID=B.UID and A.value=B.value)