Need help on building SO information with invoice SQL Query

Hello,

How to derive the following information.is there any SQL for this:

Data to include all fields, including (if available):

• Invoice Number

• Booking/Sales Order Number

• Customer Name and Customer Number

• End Customer Name and Number

• Product Name, Category & Description

• Shipped Date

• Quantity Shipped

• Unit Price

• Invoice Amount