Discussions
Read on for the latest updates including:
• Agenda Builder launch
• SuiteWorld On Air registration
• New NetSuite Prompt Studio Contest
• And more!
Check out this thread to learn more!
CTE query with ODBC
Hi,
I am trying to query Netsuite via (excel) ODBC to find sales order number associated to Credit Memo. Since most of our Credmem are created from invoices (but sometimes are more complicated), I am trying to create a recursive SQL query but it doesn't work and I wonder if it is the ODBC connector that prevents it ? Or my query.
with calnumber as (
select id, tranid, createdfrom from transaction
where tranid = 'something'
union all
select child.id, child.tranid, child.createdfrom from transaction as child
join calnumber as parent on parent.id = child.createdfrom )
select * from calnumber;