Pull orders by sku?

Just curious, and I assume tables may have to tie together similar to how you would JOIN in MySQL, but I am trying to see if possible to pulls Orders through Sku. Infusionsoft itself doesn’t allow exporting sales through a report natively, so trying to do this through API, or seeing if possible. I am able to grab and display the sku based on productId, and curious if able to pull relational data from that, particularly orders.

The IS API doesn’t provide anything comparable to a JOIN. You would have to pull a list of products by SKU and return the product id and then do a separate query on the InvoiceItem table querying by OrderItemId in order to discover the orders that contain a product with a specific SKU.