TABLE1
NAME ID DATE
A 1 2019-04-01
A 2 2019-04-02
B 1 2019-04-01
B 2 2019-04-01
select ID ,DATE from TABLE1 where NAME='A'
minus
select ID ,DATE from TABLE1 where NAME='B'
I wish UPDATE B same information(ID,DATE)
UPDATE SQL??
UPDATE TABLE1 SET ........................................
WHERE NAME='B'