# F041-08: All comparison operators are supported (rather than just =)

statement ok
CREATE TABLE TABLE_F041_08_01_011 ( ID INT PRIMARY KEY, A INTEGER );

statement ok
CREATE TABLE TABLE_F041_08_01_012 ( ID INT PRIMARY KEY, B INTEGER );

query II
SELECT TABLE_F041_08_01_011.A, TABLE_F041_08_01_012.B FROM TABLE_F041_08_01_011 JOIN TABLE_F041_08_01_012 ON TABLE_F041_08_01_011.A < TABLE_F041_08_01_012.B

statement ok
CREATE TABLE TABLE_F041_08_01_021 ( ID INT PRIMARY KEY, A INTEGER );

statement ok
CREATE TABLE TABLE_F041_08_01_022 ( ID INT PRIMARY KEY, B INTEGER );

query II
SELECT TABLE_F041_08_01_021.A, TABLE_F041_08_01_022.B FROM TABLE_F041_08_01_021 JOIN TABLE_F041_08_01_022 ON TABLE_F041_08_01_021.A <= TABLE_F041_08_01_022.B

statement ok
CREATE TABLE TABLE_F041_08_01_031 ( ID INT PRIMARY KEY, A INTEGER );

statement ok
CREATE TABLE TABLE_F041_08_01_032 ( ID INT PRIMARY KEY, B INTEGER );

query II
SELECT TABLE_F041_08_01_031.A, TABLE_F041_08_01_032.B FROM TABLE_F041_08_01_031 JOIN TABLE_F041_08_01_032 ON TABLE_F041_08_01_031.A <> TABLE_F041_08_01_032.B

statement ok
CREATE TABLE TABLE_F041_08_01_041 ( ID INT PRIMARY KEY, A INTEGER );

statement ok
CREATE TABLE TABLE_F041_08_01_042 ( ID INT PRIMARY KEY, B INTEGER );

query II
SELECT TABLE_F041_08_01_041.A, TABLE_F041_08_01_042.B FROM TABLE_F041_08_01_041 JOIN TABLE_F041_08_01_042 ON TABLE_F041_08_01_041.A = TABLE_F041_08_01_042.B

statement ok
CREATE TABLE TABLE_F041_08_01_051 ( ID INT PRIMARY KEY, A INTEGER );

statement ok
CREATE TABLE TABLE_F041_08_01_052 ( ID INT PRIMARY KEY, B INTEGER );

query II
SELECT TABLE_F041_08_01_051.A, TABLE_F041_08_01_052.B FROM TABLE_F041_08_01_051 JOIN TABLE_F041_08_01_052 ON TABLE_F041_08_01_051.A > TABLE_F041_08_01_052.B

statement ok
CREATE TABLE TABLE_F041_08_01_061 ( ID INT PRIMARY KEY, A INTEGER );

statement ok
CREATE TABLE TABLE_F041_08_01_062 ( ID INT PRIMARY KEY, B INTEGER );

query II
SELECT TABLE_F041_08_01_061.A, TABLE_F041_08_01_062.B FROM TABLE_F041_08_01_061 JOIN TABLE_F041_08_01_062 ON TABLE_F041_08_01_061.A >= TABLE_F041_08_01_062.B
