0001 create temporary view nt1 as select * from values
0002 ("one", 1),
0003 ("two", 2),
0004 ("three", 3)
0005 as nt1(k, v1);
0006
0007 create temporary view nt2 as select * from values
0008 ("one", 1),
0009 ("two", 22),
0010 ("one", 5)
0011 as nt2(k, v2);
0012
0013
0014 SELECT * FROM nt1 natural join nt2 where k = "one";
0015
0016 SELECT * FROM nt1 natural left join nt2 order by v1, v2;
0017
0018 SELECT * FROM nt1 natural right join nt2 order by v1, v2;
0019
0020 SELECT count(*) FROM nt1 natural full outer join nt2;