SQL Query in MAxDB..
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..