4
I have a table called Tabela1
and another call Tabela2
:
Tabela 1 Tabela2
Indice, pessoa_id sts, pessoa_id
The index goes from 0 to 10, and sts
can be ON-LINE
, OFF-LINE
OR ON-LINE-PAUSADO
.
I wish that when I gave the select
, come back ordered, but if any of these people are with the sts
equal to 'online-paused', come at the end of the select
.
Example:
indice, pessoa_id, sts
4 , 2 , 'ON-LINE'
5 , 2 , 'ON-LINE'
6 , 2 , 'ON-LINE'
8 , 2 , 'ON-LINE'
1 , 2 , 'ON-LINE-PAUSADO'
2 , 2 , 'ON-LINE-PAUSADO'
This makes it clearer: http://prntscr.com/mn5fr8
– Gustavo Pedro
But
ON-LINE
is also being presented in your example... I don’t understand what you want to do. If it isON-LINE-PAUSADO
need to show, if it is not show anything?– Pedro Paulo
It worked, thanks for your time, hug :D https://i.stack.Imgur.com/oXNEr.png
– Gustavo Pedro