How to construct CAML queries?

CAML Query Tools
http://msdn.microsoft.com/en-us/library/ff648040.aspx

U2U CAML Builder
http://www.u2u.net/res/Tools/CamlQueryBuilder.aspx

  • U2U CAML Query Builder Feature. This is a SharePoint version of the U2U CAML Query Builder tool. It is installed as a feature; developers can use it to build queries directly inside of SharePoint.
  • Stramit SharePoint CAML Viewer. This is a Windows-based application that is similar to U2U CAML Query Builder.
  • CAML.NET. This is a .NET Framework assembly that provides an abstraction to CAML. Developers can use it to dynamically create queries with a set of .NET Framework classes.