If you are relatively new to using CAML (which if you are going to be customizing SharePoint, you most likely will), there is a great tool out there to help learn. Patrick Tisseghem has a blog at http://www.u2u.info where he posts a lot of information centered around SharePoint.
For his entry on the U2U CAML Query builder: http://www.u2u.info/Blogs/Patrick/Lists/Posts/Post.aspx?ID=1252
This is a great tool for assisting in building your queries. Just note that if you are going to use the output of this tool in C# or VB.Net classes, you will need to use the unique name that SharePoint assigns to the column, which is a modified GUID. To get the details on your columns in a List, use the GetList method in the List web service. Your resulting set will show the display name that you are familiar with but also something similar to: Name="xd__x007b_F18C5698_x002d_C5B6_x002d_4D60_x002d_B42C_x002d_61D89A229F82_x007d_, which is the name you will need to reference in your code.
Here is a screenshot of the application:
Tags:
Categories: SSIS