econz icon

Firebird - Insert from Select

econz | PRO | 04/03/13 07:25:40 PM UTC | 0 ⭐ | 650 👁️ | Never ⏰ | []
SQL |

220 B

|

None

|

0 👍

/

0 👎

Raw Download Clone Embed Print View 
   INSERT INTO DESTINO(CODIGO,
                       DESCRICAO,
                       NUMERO)
      SELECT
         O.COD_ORIGEM,
         O_DESC_ORIGEM,
         0
      FROM Origem O
      WHERE
         O.TIPO='R' ;

Comments