android 多表联合查询 as 用法 -----断点记录

想查询出通话日志中的通讯录,发现如果用

String selection ="0=0) group by (date"

String [] projection = new String []{

"_id",

"(select [data] from photos as photos where photos.person =(select person from phones as phones where phones.number = number)) as avatars", // 头像

};

query(URI,projection,selection,null,null,null);

显示的时候总是显示同一个头像,

把sql语句放数据库中执行也是如此.

后面在数据库中写了 没有错误数据的sql语句:

select _id,

  (select [data] from photos as photos where photos.person =(select person from phones as phones where phones.number = as    calls. number)) as avatars

from calls as calls 

这里用到了 as..

但是却在java中怎么写卡住了.

后面结果版主的指点

写法如下:

 

String [] projection = new String []{

 

"_id, (select [data] from photos as photos where photos.person =(select person from phones as phones where phones.number = as    calls. number)) as avatars

from calls as calls --"   // 用到了 "--" 注释 //注释所有以后系统自动生成的sql语句

};

query(URL,projection,null,null,null,null);

达到了想要的效果.

20110919