Is there anyway to do a

left join

in NetSuite search? I have a customer search, and I am joining their transactions. I want to be able to get customers who don't have any transactions as well. But NetSuite only supports `inner join`s does anyone know a way to get these into the search?

Do a search from the customer record joined to transactions table

I think they are inner joins, they only display when a customer has a transaction. If there are no transaction, then that customer doesn't get displayed as well because there isn't a match

You can do a customer search, and instead of adding filters for the transaction criteria you want, use formulas in the result columns with case statement to filter. However that will be very very slow.

you can try using expressions and adding the filter

Or Transaction : Internal ID is none