4th Shift SQL question

I'm sorry if this is the wrong group, this is my first time in any of the groups.  I am trying to get CO line item information given an invoice number.  I would like to know what CO numbers were paid on an invoice and what line items there were for each CO number.