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.
SharePoint Stack Exchange is a question and answer site for SharePoint enthusiasts. It only takes a minute to sign up.Sign up to join this community
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