Mahathi
Old Hand
Points: 320
More actions
June 30, 2006 at 1:07 am
#114157
Can we use Where condition and Select statement in an INSERT statement? If so how can we do it? Thanks in advance.
Mahathi.
Claudia-343424
Ten Centuries
Points: 1080
June 30, 2006 at 1:20 am
#646891
What do you mean?
You can do this
Insert into Table (column1,column2....)
select columna, columnb....
Where [condition]
Is this the answer that you were looking for?
Claudia
June 30, 2006 at 1:45 am
#646899
Yes. Thank you for the reply given.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply