Help needed for sql query : Procedure & Insert trigger

Hi everyone,

I want to write a procedure in which one can register sales....The sales come into a table called online sales...

After the data have been inserted in the first table, there are a number of sales which need to be copied to a new table, through a trigger event.

Therefore i need to insert a condition, after when it is met, to put a number of the register sales data into a new table (with primary key, transit_sale_id).

There is one remark however. 4 colums from the online sales table can NOT be directly mapped from the first table, but they need to be joined with different tables.



If anyone could help,

it would be much appreciated.