It could be obvious but since I don't have any experience I cannot figure out how to do. Here is the question; say I have table2 with fields id,name, time, price and explanation.Also, there is an other table1 which has name, time and price. I want to insert data from table1 if price is higher than some threshold, while doing so as an explanation I want "The price is above threshold". Can anyone suggest me a way to do so? Thanks in advance.