how to query multiple Sp list using spservices lib

Jun 4, 2011 at 6:24 PM
Edited Jun 4, 2011 at 6:26 PM

Hi All,

I have 3 list 

1. Post list with ID

2.Image Library(for storing big image) with a custom column Called Article ID(Post List ID foreign key)

3.Image Library(for storing thumbnail image) with a custom column called Article ID(post list ID foreign key)

how can i return the item with all the items joining all the 3 lists filtering with ID on the post list.

As per i know i can do it using 3 queries and selecting the XML with a logic.Can  we have any functions in SPServices library from we can achieve the same.

 

Thanks for all your support.

Janesh Hari

Coordinator
Jun 4, 2011 at 6:32 PM
There's no concept of a join in CAML. You'll need to manage the connections in your script.

However, this sounds like a good candidate for a DVWP instead. Still no join, but you can do the work server side in XSL.

M.
>
Jun 5, 2011 at 7:02 AM

Thanks :-). going to dig more abt DVWP.