[sqlite] How to disambiguate duplicated column names when joining two tables?

[Simon Slavin]

On 13 Mar 2016, at 11:39pm, Peng Yu <pengyu.ut at gmail.com> wrote:

> Is there a syntax to disambigurate the duplicated
> column names?

You can use the table names in your SELECT in the same way as you use them in 
the JOIN:

select * from A join B on A.a=B.a;
a           b           c           a           b           d
----------  ----------  ----------  ----------  ----------  ----------
1           4           7           1           4           7
2           5           8           2           5           8
2           15          18          2           5           8

SELECT A.b from A join B on A.a=B.a;
 will give 4,5,15
SELECT B.b from A join B on A.a=B.a;
 will give 4,5,5

Simon.