On 7/8/2014 4:01 PM, Paul Sanderson wrote:
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
select recno, t2.name, t3.name
from t1 join t2 using (a) join t3 using (b);
--
Igor Tandetnik
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users