In this article, we get started with the orders desk and accomplish a remaining outer be part of with both of those the users and solutions tables. This makes sure that all orders are included in the result set, combined with the matching consumer names and solution names if readily available. MANUAL : Specify both the automatic archive manner or p