FQL的新手,想要提取“其他”邮箱存档或没有,并按用户分组所有正文消息。下面的查询示例仅获取收件箱中的每封邮件。folder_id
是收件箱的0
,发件箱的1
和更新的4
。另一个收件箱的选项是什么?
SELECT message_id, thread_id, author_id, body, created_time, attachment FROM message WHERE thread_id IN (SELECT thread_id FROM thread WHERE folder_id = 0)
发布于 2013-12-24 15:16:29
使用OR运算符
SELECT message_id,thread_id,author_id,body,created_time,attachment message WHERE thread_id IN (SELECT thread_id FROM thread WHERE folder_id =0或folder_id =1或folder_id = 4)
https://stackoverflow.com/questions/13995761
复制相似问题