I am building a GI that would link service orders with sales order. In this case, the service order is not created from the sales order, so they are not inherently linked. Instead, the sales order number is entered manually in the description of the service order.
So I am looking to join the service order and sales order tables through the service order description text field. How would I do this join?
The join above is not getting me any results.
