sqlite3 联表查询 代码

1. select USER.USERNAME, USER.USERNAMEP, USER.PHOTOURL, USER.ADMIN, USEREX.RELATION, USEREX.SUBRELATION, USEREX.LASTTIME, _MESSAGE.CONTENT, _MESSAGE.SENDTYPE, _MESSAGE.DIRECTION \ from USER, USEREX left join (select CONTENT, max(TIMETAG) as MAXTIMETAG, DIRECTION, SENDTYPE from MESSAGE where MYID = ? and USERID = ? and GROUPID = 0)_MESSAGE \where USER.USERID = ? and USEREX.USERID = USER.USERID and USEREX.MYID = ? and USEREX.LASTTIME > 0;
2. (select xxx from xxx left join(select xxx from xxx where xxx) xxx where xxx);