how to join two saved search using join field

AI generated answer (using internal Slack threads):

In NetSuite, you can join two saved searches using join fields. However, this is not a direct join like in SQL, but rather a way to pull in related data from another record type. Here's a general approach: 1. Identify the common field between the two saved searches. This field will be used as the join field. 2. In your primary saved search, add a new column for each field you want to pull in from the second saved search. 3. For each new column, select the join field from the dropdown list. This will pull in the related data from the second saved search. For example, if you have a Vendor Bill saved search and a Payments saved search, and you want to add a payment column to the Vendor Bill search, you could do the following: 1. Add a new column in the Vendor Bill search. 2. For the field, select 'Payment' from the dropdown list. 3. For the join, select the common field between the Vendor Bill and Payments (e.g., 'Vendor'). Please note that this approach might require some adjustments depending on the specifics of your saved searches and the data you're trying to pull in. ****** Disclaimer: This response was generated by an artificial intelligence assistant based on previous conversations from multiple Slack channels, and may contain inaccuracies or mistakes. ******