Two Different Table but some Common Fields data inserting

Hemal Joshi

Hello,

I have developed an C# windows application where i have Two tables like MMMEMBER and MMSH_MAST and in MMMEMBER table Common Fields are MNO,OP_DT now in that table i have already enterd both fields data and now in my application i have fetch that data when combobox select any MemberNo it's related data will display in textboxs through Store Procedure and in My Second MMSH_MAST table MNO and OP_DT fields are common now how can i get these two fiedls data autometically form MMMEMBER table suggest me query for that.

Thanks..

3 Replies

Know the answer? Post it — somebody with the same question will find it here.

Hemal Joshi8y ago
Hi,

I have got the solution for that in sql query: Insert into MMSH_MAST(MNO,OP_DT) select MNO,OP_DT from MMMEMBER;
+1
Hemal Joshi8y ago
Hi Ramesh,

Brother but i have to need both columns data to add autometic in the MMSH_MAST table from MMMEMBER u have suggest any sql query or code with images that will help me more better.
0
Ramesh Palanivel8y ago
Hi Hemal,

Instead of having these both columns in two tables, make relationship with each other. Then using any one of forign key relation, you can get required values from table.
+1