enter image description here

How can I write one caml query to get items from two lists joined on empid? will you please anybody give me help with suitable caml query or even otherwise possible code.

Note: There is no lookup coumns in this two lists.

1 Answer 1


You can do this in three steps:

1 Grab all the items of the two lists

2 Check the items that are equal. Save the Id of the items that have the same value

3 Register the items of you got id in the list 3

You can improve this logic, but basically this is what you should do

You should write the query according to your need

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.