How to query specific list using SPSiteDataQuery?

How to query specific list using SPSiteDataQuery?
Query.Lists="    <Lists><List ID=”960BF6F6-F264-4305-B3CB-BDB9BF8F67DF” /></Lists>" – query a specific list  

Using Folder, FilesOnly, Recursive, RecursiveAll in SPquery in SharePoint

http://spdailytips.blogspot.in/2011/09/using-folderfilesonlyrecursiverecursive.html

 

Joins in SPQuery

http://msdn.microsoft.com/en-in/library/ee539975%28v=office.14%29.aspx

http://sprider.org/2011/07/09/sharepoint-2010-list-joins-spquery-enchancements/

http://sharepointfordeveloper.blogspot.in/2011/10/step-by-step-spquery-list-joins.html

SPQuery Quick Guide 

view plainprint?

1. //Query on single line of text:  
2. <query><where><eq><fieldref name="Title"><value type="Text">SingleLineOfText</value></fieldref></eq></where></query>  
3.   
4. //Query on Multiline of text: - note use of [CDATA[] to avoid parsing errors  
5. <query><where><contains><fieldref name="Body"><value type="Text"><![CDATA[Search Criteria]]></value></fieldref></contains></where></query>  
6.   
7. //Query on Person or Group (By Name)  
8. <query><where><eq><fieldref name="Author"><value type="Text">Sasi Kumar Reddy</value></fieldref></eq></where></query>  
9.   
10. //Query on Person or Group (By ID)  
11. <query><where><eq><fieldref lookupid="TRUE" name="State"><value type="Lookup">4</value></fieldref></eq></where></query>  
12.   
13. //Query on SPUser ID  
14. <query><where><eq><fieldref lookupid="true" name="SlaesPerson">  
15. <value type="User">7</value> </fieldref></eq></where></query>  
16.   
17. //Query on SPUser Name  
18. <query><where><eq><fieldref name="SalesPerson"><value type="User">john</value></fieldref></eq>   
19.  </where></query>  
20.   
21. //Query on DateTime Only  
22. <query><where><eq><fieldref name="Created"><value type="DateTime">2012-01-10</value></fieldref></eq></where></query>  
23.   
24. //Query on DateTime   
25. <query><where><eq><fieldref name="Created"><value includetimevalue="TRUE" type="DateTime"><today></today></value></fieldref></eq></where>></query>  
26.   
27. //Query on Lookup by text  
28. <query><where><eq><fieldref name="State"><value type="Lookup">SasiReddy</value></fieldref></eq></where></query>  
29.   
30. // Query on Lookup by ID  
31. <query><where><eq><fieldref lookupid="TRUE" name="State"><value type="Lookup">108</value></fieldref></eq></where></query>  
32.   
33. // Query on Today date  
34. <query><where><eq><fieldref name="Created"><value type="DateTime"><today></today></value></fieldref></eq></where></query>  
35.   
36. // Query on last week  
37. <query><where><eq><fieldref name="Created"><value type="DateTime"><today offsetdays="-7"></today></value></fieldref></eq></where></query>  
38.   
39. //Query to return only empty columns,   
40. query.ViewFields="<fieldref name="Description" nullable="TRUE">";    
41. </fieldref>  

Best Reference:

http://joshmccarty.com/2012/06/a-caml-query-quick-reference/

http://www.paint-it-yellow.co.uk/bobsblog/?p=472

http://snahta.blogspot.in/2009/07/spquery-few-important-things.html

http://ranaictiu-technicalblog.blogspot.in/2009/11/sharepoint-user-idname-in-spquery.html

http://kartooz.wordpress.com/2009/02/12/using-spquery-to-filter-lists-by-domain-user-account-and-spuser-id/ 

Thanks,

jayasankar