insert into cmif_h
(Mandant, AppID, CUser, CDate, MUser, MDate, IUser, IDate, FUser, FDate)
values
(select 
	Mandant, AppID, CUser, CDate, MUser, MDate, IUser, IDate, FUser, FDate 
 from
	cmif
 where
	Mandant = 5 and
	AppID = 403220766
)

quote:

---

Originally posted by omsec

Yep, it's me again :-)

I have two Tabels, that look similar but not exactly the same. I wonder, what is the best way to copy a record from one Table to another. I tried something like this, which did not work:

insert into cmif_h
(Mandant, AppID, CUser, CDate, MUser, MDate, IUser, IDate, FUser, FDate)
values
(select 
	Mandant, AppID, CUser, CDate, MUser, MDate, IUser, IDate, FUser, FDate 
 from
	cmif
 where
	Mandant = 5 and
	AppID = 403220766
)

My Idea: I thought if I provide a result set that contains the same fields in the same order as specified in the INSERT INTO statement I could archive some "on-the-fly" copy operation.

Thanks in Advance - Roger

---

insert into cmif_h
(Mandant, AppID, CUser, CDate, MUser, MDate, IUser, IDate, FUser, FDate)
select 
	Mandant, AppID, CUser, CDate, MUser, MDate, IUser, IDate, FUser, FDate 
 from
	cmif
 where
	Mandant = 5 and
	AppID = 403220766

quote:

---

Originally posted by Jeff Moden

I guess my question is "Why do you need identical data in two different tables"? Kinda goes against the idea of a database, in general.

--Jeff Moden

---

quote:

---

Originally posted by Jeff Moden

I guess my question is "Why do you need identical data in two different tables"? Kinda goes against the idea of a database, in general.

--Jeff Moden

---