Share with colleagues and friends who could benefit from our webinars too!
CTE query with ODBC
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'
select child.id, child.tranid, child.createdfrom from transaction as child
join calnumber as parent on parent.id = child.createdfrom )
select * from calnumber;