Hi,

I was trying out YQL for ymail tables and I couldn't figure out how to get email content for a specific email using its mid or a list of content using a list of mids.

A few queries that I tried either did not return results or returning more than what it should based on the the query conditions.

1) select * from ymail.msgcontent where mids in ('mid_goes_here')
2) select * from ymail,msgcontent where fid = 'fid_goes_here' and mids in ('mid_goes_here')
3) select * from ymail.messages where mid = 'mid_goes_here' (tried in clause also). This one returns a bunch of messages

I modified the sample

select message from ymail.msgcontent where (fid,mids) in (select folder.folderInfo.fid,mid from ymail.messages where query="Yahoo" limit 1)

to 

select message from ymail.msgcontent where (fid,mids) in (select folder.folderInfo.fid,mid from ymail.messages where mid='mid_goes_here') and it returns a bunch of messages

The mid(s) that I use are ones that I got back from "select hits.mid from ymail.search where fid='fid_goes_here' and subject in ('subject_token1', 'subject_token2',..) and date-start > value

I'm I doing this correctly or did I missed something?

Thanks,

Chinh Tran