I like to retrieve data from two linked lists. Tried CQWP but the XML was too difficult. The parent list is PIR, the child is SIR. They are linked through the field PIR2SIR (lookup) in the child list.
PIR 1 my question date1 SIR 1.1 my subquestion SIR 1.2 my subquestion PIR 2 my question date2 SIR 2.1 my subquestion
What code do I need with the SPSiteDateQuery to get a listview like that?