@shubs joins in all searches have limitations. You may create a join if the fields are available from the list of join fields. Like for example. Pulling the assigned currency of the customer record in a sales order search, where Search Type = Transaction. The join to pull the currency field shall be Customer fields... so if the specific source data is not available in the list not available for selection, then you can't join. 😞