Select t1.uuid, t2s1.id is

Question

Select t1.uuid, t2s1.id is

not null as state1,
t2s2.id is not null as state2
from table1 t1
left join table2 t2s1 on t2.t_uui = t1.uuid and t2.state = 'state1'
left join table3 t2s2 on t2.t_uui = t1.uuid and t2.state = 'state2'
group by t1.uuid

MySQL такое должно пропустить. PgSQL ругнётся. Какая СУБД?

#russian #software #symfony

0

08.02.2019

1 ответов

14 просмотров

В · Accepted Answer

В

Select sums from (select distinct t1_id, status)

0

08.02.2019

52 похожих чатов

Select t1.uuid, t2s1.id is

1 ответов

Похожие вопросы