DescribeQuery (children 1) TableExpression (children 1) Subquery (children 1) SelectWithUnionQuery (children 1) ExpressionList (children 1) SelectQuery (children 2) ExpressionList (children 6) Identifier test_table_join_1.id Identifier test_table_join_1.value Identifier test_table_join_1.value_join_1 Identifier test_table_join_2.id Identifier test_table_join_2.value Identifier test_table_join_2.value_join_2 TablesInSelectQuery (children 2) TablesInSelectQueryElement (children 1) TableExpression (children 1) TableIdentifier test_table_join_1 (alias t1) TablesInSelectQueryElement (children 2) TableExpression (children 1) TableIdentifier test_table_join_2 (alias t2) TableJoin (children 1) Function equals (children 1) ExpressionList (children 2) Identifier t1.id Identifier t2.id