sqlite3 ¶à±í²éѯ·½·¨

¶à±í²éѯ·½·¨£º

sqlite3¿ÉÒÔÓжàÖÖ¶à±í²éѯ·½·¨£¬±ÈÈç select (select * from table2) from table1 where xxx=xxx;

ÕâÖÖ·½·¨±È½Ï¼òµ¥²¢ÇÒ¸ßЧ£º

select table1.abc from table1,table2 where table1.xxx=table2.xxx;

»òÕâÖÖ

select table1.abc from table1 inner join table2 on table1.xxx=table2.xxx;