I suspect this is easy i have three tables
create table t1 (recno int, a int, b int) create table t2 (a int, name text) create table t3 (b int, name text) I want to create a query that lists all rows in t1 but rather than the integers a and b I want to display the associated names from t2 and t3 so if t1 had 0, 1, 2 1, 2, 2 2, 2, 1 t2 is 1 microsoft 2 oracle t3 is 1 pc 2 mac a select * from t1 (using some sort of join) would show 0, microsoft, mac 1, oracle, mac 2, oracle, pc Hope this is clear. Thanks _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
