<div>
<div class="content wysiwyg-content">
I have a list named &nbsp;test1 and another list named test2. The fields in test1 are Id, Title, Body and fields in test2 are Id, test1 Id, Title, Body. Now here i want to make a sp query with test2 list to select Title from test1 list where test1 Id is equal to some value (let's say 1)<br />
<br />
Can anybody help me to do this by SharePoint list query
</div>
</div>


I have a list named  test1 and another list named test2. The fields in test1 are Id, Title, Body and fields in test2 are Id, test1 Id, Title, Body. Now here i want to make a sp query with test2 list to select Title from test1 list where test1 Id is equal to some value (let's say 1)

Can anybody help me to do this by SharePoint list query

Get Title from a list by storing its Id in another list

Microsoft Sharepoint is a software platform and family of software products used for collaboration and web publishing combined. These capabilities include developing web sites, portals, intranets, content management systems, search engines, wikis, blogs, and other tools for business intelligence and collaboration. SharePoint has a Microsoft Office-like interface, and it is closely integrated with the Office suite.