select * from k1 union select * from k2; >-----Original Message----- >From: sqlite-users-boun...@sqlite.org [mailto:sqlite-users- >boun...@sqlite.org] On Behalf Of YAN HONG YE >Sent: Thursday, 3 April, 2014 19:46 >To: sqlite-users@sqlite.org >Subject: [sqlite] if possible point another table > >I have a table named aa like this: >id pid name note tablename >1 0 s12 bbc k1 >2 1 sss vac k2 > >another table named k1: >id pid name note >11 1 f2 aaa >12 1 fs bbc > >another table named k2: >id pid name note >31 2 f2 aaa >32 2 fs bbc > >my question is: in table aa, if possible k1 point to another table "k1"? >select tablename from aa; >I want result is: >id pid name note >11 1 f2 aaa >12 1 fs bbc >31 2 f2 aaa >32 2 fs bbc > > >_______________________________________________ >sqlite-users mailing list >sqlite-users@sqlite.org >http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
_______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
