SAP Business One sales query

Dear Experts,

I will like a query with a join on sales order, sales delivery and sales invoice.

Customer can prepare a sales order and then copies it to sales delivery and finally moves it to sales invoice. The customer can at the same time prepare sales order and finally move it to sales invoice.

I want a query to handle both scenario in the image below;

Regards,

Justice Doku