Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

SQL Query in MAxDB..

Hi Friends,

Could you please let me know what should i change to execute the query in MaxDB?

select distinct t1.*, iif(t2.id is NULL, 0, 1) as hassub from content t1 left join content t2 on (t1.id=t2.parent_id) where t1.parent_id=" & id & " order by t1.parent_id,t1.sort

Thanks for ur help..

Rgds,

Pradeep

Former Member
Not what you were looking for? View more on this topic or Ask a question