It's possible use join in CAMLQuery?

Apr 15, 2011 at 4:01 PM

Hi, I need to develop a filter that query two or more list, how could I use something like join in camlquery?

Regards.

Coordinator
Apr 15, 2011 at 4:27 PM

Unfortunately there's no formal "join" (al la SQL) with CAML. You could nest two web service calls to accomplish what you need, but depending on how much data you have that's potentially very inefficient.

There are some ways to do join-like sub queries with data views, but that is obviously out of the scope of SPServices.