How to configure sqldatadapter with query like
"select name ,id from tlb1 where id in (select id from tlb2 where dept=@.dept)"
Is the nested subquery is not allowed while configuring sqldaadapter?
Swati
Hi Swati Jain,
Is the nested subquery is not allowed while configuring sqldaadapter?
I don't think so. I tested your code in my project and it works fine. There must be something wrong somewhere else in your code. Also a workaroud here is to use table join instead of nested sql.
Hope my suggestion helps
