Hi,
in this kind of statements:
SELECT a, b, table2.c, alias.c
FROM table1
LEFT JOIN table2 ON ...
LEFT JOIN table2 AS alias ON ...
the API sqlite_column_table_name() applied to both columns 3 and 4
returns <table2>. I know that <c> belongs to <table2> in both cases, but
is there any way to get <table2> for column 3 and <alias> for column 4?
TIA,
Jose F. Gimenez
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users