Complicated Insert Statement

jkruer01 · #1 (**permalink**) 10-08-04, 09:18

Hello,

I have a question. I have two tables tableOne has a fields bug_id and resolution. TableTwo has fields bug_id, version_type, and version.

I need to create an insert statement that inserts the tableOne.bug_id into tabletwo.bug_id where tableOne.resolution='DOCUMENTED'.

Can someone please show me how to do this?

Thanks!

RBARAER · #2 (**permalink**) 10-08-04, 09:48

Hello,

Well, it is almost as you have written it :

Code:

Insert into tabletwo(bug_id) 
select bug_id 
from tableone 
where resolution='DOCUMENTED';

Regards,

RBARAER

jkruer01 · #3 (**permalink**) 10-08-04, 10:10

Thanks, that did exaclty what I wanted. I have never used an insert statement like that before.

Internet Services

Web Development

Digital Marketing

Consumer Tech