/
krasninja
/
querycat
Обзор
Документация
Войти
/
krasninja
/
querycat
Код
Пакеты
0
Релизы
0
Аналитика
Безопасность
develop
src/QueryCat.IntegrationTests/Tests/SelectSubquery/SelectSubquery4.yaml
11 строк
309 B
Ivan Kozhin
Group tests
20 май 2024, 11:20
20 май 2024, 11:20
089ba20
Код
Авторство
О чём код?
expected: | 1,a,1,xxx 2,b,, query: | select t1.num, t1.name, t3.num, t3.value from 'Table1.csv' as t1 left join ( select * from 'Table2.csv' as t2 where t2.num > 8 and exists(select t4.value from 'Table2.csv' as t4) union select * from 'Table2.csv' ) as t3 on t1.num = t3.num limit 2;