I am inserting records into a table from another table through a procedure. While inserting I also need to add few additional columns into destination where one of the additional column value should get from another table through a query based on the existing field.
Source Destination
C1 C1
C2
Here I have to take value for C2 from another table based on C1 value
Table3
C1,C2
Can some one help in writing query to get C2 based on C1 for insert.
Thanks.