> Hi, The following example shows that there will be duplicated column names > in the joined table. Is there a syntax to disambigurate the duplicated > column names?
See the deprecated pragma's short_column_names and full_column_names. The correct answer is to use AS to specify the names you want for the columns in the result set. If you are using the C API and sqlite3 was compiled with SQLITE_ENABLE_COLUMN_METADATA then you can all the column metadata functions to retrieve that information. The sqlite3 command shell does not retrieve column metadata. https://www.sqlite.org/capi3ref.html#sqlite3_column_database_name
