View - Pasted

text |

470 B

None

0 👍

0 👎

Raw Download Clone Embed Print View

/* CabinetContracts - ContractsView */
 Select c.id_contract
      ,ps.name_Kind_paragraph
      ,ps.Status_Text
      ,c.d_start
      ,c.d_end
      ,c.dp_end
From web_user_wp wu
    ,employees_  e
    ,contracts_  c
    ,paragraphs_status_ ps
Where
    wu.id_web_user = :Bind_IdWebUser
    and wu.id_e_kis = e.id_e
    and e.id_contractor = c.id_with_whom
    and c.id_paragraph = ps.id_paragraph
 Order by c.d_start desc, ps.name_Kind_paragraph, ps.Status_Text

Comments

01/01/70 12:00:00 AM UTC
Plain Text |
0 B
|
👍
/
👎