clear markdown compare help donate or buy diddy dollings comments/suggestions/bugs a leap of faith? bible365
clear markdown donate comments/suggestions/bugs a leap of faith? bible365 diddy dollings
By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0. 709926 fiddles created (14148 in the last week).

CREATE TABLE T1 ( rnum INT NULL, NAME NVARCHAR(32) ) CREATE TABLE T2 ( rnum INT NULL, NAME NVARCHAR(32) ) INSERT INTO T1 (rnum, NAME) VALUES(1, 'A'), (2, 'B'), (3, 'C'), (4, 'D'), (5, 'E'), (6, 'F'), (7, 'G'), (8, 'H'), (9, 'I'), (10, 'J') INSERT INTO T2 (rnum, name) VALUES(1, 'A'), (2, 'B'), (3, 'C'), (4, 'D'), (5, 'E'), (6, 'F'), (7, 'G'), (8, 'H'), (9, 'I') select a.*, b.* from t1 a LEFT OUTER JOIN t2 b on a.rnum-1 = b.rnum
rnum NAME rnum NAME
1 A
2 B 1 A
3 C 2 B
4 D 3 C
5 E 4 D
6 F 5 E
7 G 6 F
8 H 7 G
9 I 8 H
10 J 9 I
 hidden batch(es)