Discussions
Stay up-to-date with the latest news from NetSuite. You’ll be in the know about how to connect with peers and take your business to new heights at our virtual, in-person, on demand events, and much more.
New AI Community Guidelines. Please review and follow them to ensure AI use stays safe, accurate, and compliant.
SuiteQL Table Joins
Hi There
I can't find any documentation on the syntax for Suiteql.
I am trying to create multiple table joins though I am getting an 'invalid or unsupported search' error
This is the query
SELECT
TO_CHAR(CURRENT_DATE, 'YYYY') AS current_year,
SUBSTR(BUILTIN.DF(budgetsMachine.period), 5, 4) AS budgetsMachine_year,
BUILTIN.DF(budgets.account) AS budget_account
FROM
budgets
LEFT JOIN budgetsMachine ON budgetsMachine.budget = budgets.id
LEFT JOIN customer ON customer.entityid = budgets.customer
WHERE
TO_CHAR(CURRENT_DATE, 'YYYY') = SUBSTR(BUILTIN.DF(budgetsMachine.period), 5, 4);
What is the issue with the join?
I am able to query the data when I have a join on only one table
Tagged:
0