0

I am using yahoo query language with web service to retrieve yahoo mails using oauth. Now my use case is to download all emails with in given time range.

How can i construct the query to fetch data in time range?

Query i used(it is not working) : 

select message from ymail.msgcontent where (mids) in (SELECT  mid  FROM ymail.messages WHERE fid="Sent" and messageInfo.receivedDate >  1393417547

Can someone help me write a right one.

Rajeev
  • 4,762
  • 8
  • 41
  • 63

1 Answers1

0

Instead of directly selecting mid, select messageInfo.mid will fix it

Below query did the magic : select message from ymail.msgcontent where (mids) in (select messageInfo.mid from ymail.messages where messageInfo.receivedDate > 1392658116)

Rajeev
  • 4,762
  • 8
  • 41
  • 63