I am using SP 2013 and trying to joint two lists which are linked through a lookup field in the second list. I have tried several things like XML and SpSiteDataQuery but I am not familiar with using C#. I just know using javascript and jquery in SP. So what should I use in SP2013 to join the lists and present their data?
Can I use SPQuery or REST API for this? I found examples here: