In SharePoint 2007, if I had 2 lists with a master/detail type relationship (via a lookup column) how would I best implement a search query across these 2 lists (for a custom search and results page). For example a Project list and a Task list where you might want to search by Project ID, Name, Owner and Task Dates. The results would display all matching Project/Tasks in a paged grid. Is it possible to do this in CAML (I believe the answer is no!) or do we need to run separate queries against both lists and then match them up in C# somehow. There must be some proven methods for this sort of thing?
As always any help much appreciated. James.