add batch remove batch split batch comment selection show hidden batches hide batch highlight batch
db<>fiddle
donate feedback about
By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
9 rows affected
custno transId vtransId
A A123 A123
A A456 A456
A A586 A555
A null A858
B B36 null
C null C469
Warning: Null value is eliminated by an aggregate or other SET operation.

custno (No column name) (No column name)
A A586 null
A A123 A123
A A456 A456
A null A555
A null A858
B B36 null
C null C469
Warning: Null value is eliminated by an aggregate or other SET operation.