# F131-02: Multiple tables supported in queries with grouped views

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

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

statement ok
CREATE VIEW VIEW_F131_02_01_01 AS SELECT A FROM TABLE_F131_02_01_011 GROUP BY A;

query I
SELECT A FROM VIEW_F131_02_01_01 JOIN TABLE_F131_02_01_012 USING ( A )
