Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- select tabla1.campo1, tabla2.campo2
- into miTablaNueva
- from tabla1
- inner join tabla2 on tabla2.campo1 = tabla1.campo1
- where tabla1.otroCampo = 'Mi condición';
- insert into miTablaExistente (campo1, campo2)
- select tabla1.campo1, tabla2.campo2
- from tabla1
- inner join tabla2 on tabla2.campo1 = tabla1.campo1
- where tabla1.otroCampo = 'Mi otra condición';
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement