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

Reply via email to