SQL Problem

[sibusiso]

Can any one help.

I have a table the table have data I want to insert data from another table plus the data of some field on the very same table where I want to insert data.

TTest1(10 field having data)
TTest 2(5 fields having data)

I want to Insert in TTest1 by selecting 4 fields from TTest2 the other field from TTest1 I want them to remain with the same data.

but I am inserting where TTest1.ID =something

Help guys

[ck9663]

This is what caught me.

"TTest1.ID =something"

If you're trying to insert something to TTest1, then it's new. How can you check TTest1.ID ? or I'm reading to wrong?

-- CK