求列出短信息聊天记录的SQL语句…

select * from message

where

fromID in(1,2)

and

toID in (1,2)

order by time desc