I have a record that is a receipt, and in select, I want the line to be duplicated. Ex:
Select * from recibos where codigo =1;
Result:
codigo|cliente|valor|emitente|data
1 Fulano 10 Ciclano 19/10/2017
Result I need:
codigo|cliente|valor|emitente | data | via
1 Fulano 10 Ciclano 19/10/2017 1
1 Fulano 10 Ciclano 19/10/2017 2