insert no interbase

Question

estou usando interbase 6 e preciso fazer o seguintetenho 2 tabelas com os mesmos campos, EU preciso fazer um INSERT na tabela A com o conte�do da tabela b...como fa�o?...

R�mulo Barros · Answer

[code:1:217d85c281]INSERT INTO TABELA_A(CAMPO_A) VALUES ( SELECT CAMPO_A FROM TABELA_B)[/code:1:217d85c281]_____________________________________________[b:217d85c281][color=blue:217d85c281]Utilize a Ferramenta de Pesquisa do F�rum[/color:217d85c281][/b:217d85c281]Pesquisar pelos termos_____________________________________________[b:217d85c281]Veja como[url=//forum.clubedelphi.net/viewtopic.php?t=16976] OBTER RESPOSTAR R�PIDAS[/url][/b:217d85c281][b:217d85c281]Veja as novas [url=//forum.clubedelphi.net/viewtopic.php?t=59817]MUDAN�AS NA ESTRUTURA[/url] do site[/b:217d85c281][b:217d85c281]Leia sempre as [url=//forum.clubedelphi.net/viewtopic.php?t=6689]REGRAS DE CONDUTA[/url][/b:217d85c281]...

R�mulo Barros · Answer

[code:1:055bf677aa]INSERT INTO TABELA_A(CAMPO_A) VALUES ( SELECT CAMPO_A FROM TABELA_B))[/code:1:055bf677aa]_____________________________________________[b:055bf677aa][color=blue:055bf677aa]Utilize a Ferramenta de Pesquisa do F�rum[/color:055bf677aa][/b:055bf677aa]Pesquisar pelos termos_____________________________________________[b:055bf677aa]Veja como[url=//forum.clubedelphi.net/viewtopic.php?t=16976] OBTER RESPOSTAR R�PIDAS[/url][/b:055bf677aa][b:055bf677aa]Veja as novas [url=//forum.clubedelphi.net/viewtopic.php?t=59817]MUDAN�AS NA ESTRUTURA[/url] do site[/b:055bf677aa][b:055bf677aa]Leia sempre as [url=//forum.clubedelphi.net/viewtopic.php?t=6689]REGRAS DE CONDUTA[/url][/b:055bf677aa]...

Rafael Santana · Answer

valeu, MAS esse comando n�o deu certo, POR�M eu consegui...� assimINSERT INTO TABELAASELECT * FROM TABELABs� isso......

R�mulo Barros · Answer

[quote:455d16841b=�rafael miguel santana�]valeu, MAS esse comando n�o deu certo, POR�M eu consegui...� assim

INSERT INTO TABELAA
SELECT * FROM TABELAB

s� isso...[/quote:455d16841b]

:wink: :wink: :wink:

_____________________________________________
[b:455d16841b][color=blue:455d16841b]Utilize a Ferramenta de Pesquisa do F�rum[/color:455d16841b][/b:455d16841b]

Pesquisar pelos termos
_____________________________________________
[b:455d16841b]Veja como[url=http://forum.clubedelphi.net/viewtopic.php?t=16976] OBTER RESPOSTAR R�PIDAS[/url][/b:455d16841b]
[b:455d16841b]Veja as novas [url=http://forum.clubedelphi.net/viewtopic.php?t=59817]MUDAN�AS NA ESTRUTURA[/url] do site[/b:455d16841b]
[b:455d16841b]Leia sempre as [url=http://forum.clubedelphi.net/viewtopic.php?t=6689]REGRAS DE CONDUTA[/url][/b:455d16841b]

F�rum insert no interbase #273042