Posts by Renan Vieira • 45 points

2 posts

3
votes

1
answer

46
views

Q: Junction of tables

I got three tables a call CRM_PROCESSO, another call CRM_PROCESSO_VARIAVEL and the last call CRM_PROCESSO_ATIVIDADE, both have the variable idprocesso in common. What I need is for command to bring…

join table
asked 6 years ago Renan Vieira 45
1
votes

1
answer

90
views

Q: Using Case or if

I’m a beginner in SQL and I’m having difficulty using the CASE WHEN. I have a table called CRM_PROCESSO, in which you have a column with the option of Status, but the answer to this status is…

sql select if case when
asked 6 years ago Renan Vieira 45