This is a great utility which i have used countless times to generate CAML Queries.
Enjoy....
http://www.u2u.net/res/Tools/CamlQueryBuilder.aspx