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;