# F041-01: Inner join (but not necessarily the INNER keyword)

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

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

query II
SELECT TABLE_F041_01_01_011.A, TABLE_F041_01_01_012.A FROM TABLE_F041_01_01_011 JOIN TABLE_F041_01_01_012 ON TABLE_F041_01_01_011.A = TABLE_F041_01_01_012.A

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

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

query II
SELECT TABLE_F041_01_01_021.A, TABLE_F041_01_01_022.A FROM TABLE_F041_01_01_021 JOIN TABLE_F041_01_01_022 USING ( A )

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

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

# sqlparser-rs unsupported
# query II
# SELECT TABLE_F041_01_01_031.A, TABLE_F041_01_01_032.A FROM TABLE_F041_01_01_031 JOIN TABLE_F041_01_01_032 USING ( A ) AS FOO
