Hello team, I'm wondering whether once you have aliased the result of a subquery say in the SELECT statement, it would be possible to reuse that result elsewhere in the query, to avoid running the same subquery twice?

I think I've seen on here that people have had success using CTEs in SuiteQL

thanks michoel

@SimonC You can use the WITH clause, like this:

WITH 
	TestEmployee AS (
		SELECT
			ID,
			( LastName || ', ' || FirstName ) AS FullName,
			Phone,
			Email
		FROM
			Employee
		WHERE
			Email LIKE '%@test.com'
	)
SELECT 
	ID, 
	FullName 
FROM 
	TestEmployee
ORDER BY
	FullName

Thanks Tim I’ll try it out

We are using WITH in a pretty big query. Note that WITH stopped working suddenly this fall. Netsuite fixed it pretty quick though.

Thanks for the heads up