连接sms.db 然后 附加addressbook.db数据库,
ATTACH DATABASE addressbook.db as addr;
查询语句。
select message.address,message.text,addr.ABPerson.name
from message ,addr.ABPerson, addr.ABMultiValue
where message.address=addr.ABMultiValue.value
and addr.ABMultiValue.record_id=addr.ABPerson.RowID