Select ic.communication_id as child_id,

Question

Select ic.communication_id as child_id,

i.id as parent_id,
ic.communication_type as justsomeint
from crm.invoice i
left join crm.invoice_communication ic
on ic.invoice_id = i.id
where not (ic.communication_type = 2 and ic.communication_id = 5647620)
or communication_id isnull
?

#backend #devops #pgsql #programming #russian

0

11.09.2019

1 ответов

16 просмотров

Alexeyer Er · Accepted Answer

Alexeyer Er

Так, только тип тоже на нулл проверить.

0

11.09.2019

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

Select ic.communication_id as child_id,

1 ответов

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