Say for example I have this table:
Items:
-------
id
title
price
And I wanted to create a query that created a new row that for each item, it would query another table that matched the id, with the id in the other table, set the row another row in the other table.