Hemal Joshi

Hemal Joshi

  • 2k
  • 78
  • 40.2k

Insert into Select Query Question

Feb 7 2018 11:35 PM
Hello,
 
In my previous question i got the solution for that query is: Insert into MMSH_MAST(MNO,OP_DT) select(MNO,OP_DT) from MMMEMBER; but when i use these query it will affact all the records.I don't wan't that kind of things.In My Windows application One form like Share Entry and in that when i select select any number form cobobox that related data like it's MNO,MNAME, etc.. display in textbox and other fileds like Extra Share no and etc.. details are inserted by user now when i use above query it will copy all data from MMMEMBER tables and when i click on Add button it will added but as a new record. But I want to copy only selected MNO from combobox data will copy and insert into the only two fields of MMSH_MAST table fields MNO,OP_DT and other fileds data which is entered by user will insert in MMSH_MAST table.
 
Reply Soon. 
 

Answers (1)