Help finishing a SQL query

I have 2 tables (attached examples) This is what I want from the _pricing table SELECT InvoiceNumber, TransactionNumber, TransDate, Confirmation, ItemPrice, ItemTax, ItemTotalCost FROM _pricing WHERE (TransDate BETWEEN '2018-04-01' AND '2018-04-02') Here is where I need help. I need the 'SalesPrice' from the _sold table. The problem is the SalesPrice is for the total items sold not individually as they are listed in the _pricing table. Also the _pricing table and the _sold table show the confirmation a little differently. in the _sold table the confirmation starts with 'CRS-' so the comparison would need to be SUBSTRING([login to view URL],5,LEN([login to view URL])) (if that's the best way??) So what I'm looking for is a SQL query that takes all the data from the _pricing table and adds a column 'sold' from the _sold table BUT the sold Total needs to be divided by the number of items, in other words I need the individual sold price.