I had a situation where I needed to create a web part that searched all of the Document Libraries of a SharePoint site, and then gave the option to filter the list by the current user logged onto the site (similar to the "Relavent Documents" OOTB Web Part).
Anyways, the CAML Query is simplistic in nature, but was kind of a pain to reach this conclusion since most of what you will find on the Web is using the "AssignedTo" Field name to match against the current user. The key internal name field for a Document Library to use is "Editor".
Anyways, here is the "Where" clause I used to hit against the Document Libraries:
SPSiteDataQuery q = new SPSiteDataQuery();
q.ViewFields = "<FieldRef Name=\"FileRef\" /><FieldRef Name=\"ID\" /><FieldRef Name=\"Modified\" /><FieldRef Name=\"Modified_x0020_By\" />";
q.Query = "<Where><Eq><FieldRef Name=\"Editor\" /><Value Type=\"User\"><UserID/></Value></Eq></Where><OrderBy><FieldRef Name=\"Modified\" Ascending=\"False\" /></OrderBy>";
q.RowLimit = 10;
q.Webs = "<Webs Scope=\"Recursive\" />";
q.Lists = "<Lists ServerTemplate=\"101\"/>";



