Imagine this scenario - I want to create an invoice line. I have a product table of product_code and sales_price. I have the product code and quantity in the invoice line table and want to lookup the sales_price and copy it into the invoice li...