SQLite Forum

Multiply table select with table identification
Login
Is it possible to print table name in result, and how if it is...
in example:

SELECT * FROM TABLE1, TABLE2;
i'd get result
1 | 2 | 3 ---- from TABLE1
4 | 5 | 6 ---- from TABLE2

how to print 

1 | 2 | 3 | TABLE1
4 | 5 | 6 | TABLE2