IF condition JOIN this or this

Thank you, Naomi. The UNION gave me an idea how neat the resulting records could be. Unfortunately, the StockItems table and the OrderItems table are very different and it would not work in my case.