|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2001-04-18 : 17:31:25
|
spins writes "I need to know the syntax for inserting rows into a single table from multiple tables. At the momnet it looks like this:
insert into Converted_Data (EUDFLG, EUJOB, EUEVTY, convert3.EUDATE, convert3.EUTIME, EUBRAN,
EUCONS, EUEVCD, EUCOMA, EUPDSB, EUPDPL, EUPDCO, EUSHTY, EUERF1, EUUSER)
select EUDFLG, EUJOB, EUEVTY, convert3.EUDATE, convert3.EUTIME, EUBRAN,
EUCONS, EUEVCD, EUCOMA, EUPDSB, EUPDPL, EUPDCO, EUSHTY, EUERF1, EUUSER
from Uploaded_Data, convert3" |
|
Inserting data into a single table from multiple tables