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