/
krasninja
/
querycat
Обзор
Документация
Войти
/
krasninja
/
querycat
Код
Пакеты
0
Релизы
0
Аналитика
Безопасность
develop
src/QueryCat.IntegrationTests/Tests/SelectJoin/SelectJoin5.yaml
10 строк
295 B
Ivan Kozhin
Group tests
20 май 2024, 11:20
20 май 2024, 11:20
089ba20
Код
Авторство
О чём код?
expected: | 1,a,1,xxx,1,a 2,b,,,2,b 3,c,3,yyy,3,c query: | -- Join from subquery. select t1.num, t1.name, t2.num, t2.value, t3.num, t3.name from 'Table1.csv' as t1 left join (select * from 'Table2.csv') AS t2 ON t1.num = t2.num inner join 'Table1.csv' as t3 on t1.num=t3.num