Hi everyone,
I am facing a problem with an application I am developing for one of my customers. I use a multiple INNER JOIN query which returns some data I need spread in different tables. This is the query:
Normally one would expect the ColumnNames: CategoryID, Category, DepID, DepDescription, PictureFilename
Instead I get the table names instead of the column names above. Thus:
70_Categories, 70_Categories, 10_Departments, 10_Departments, 70_Pictures
I tested the same query against the database in "DBBrowser for SQLite" and it has the same behaviour.
I googled it and so far I found no solution. Has anyone faced it so far? Any suggestions?
Thanks in advance
I am facing a problem with an application I am developing for one of my customers. I use a multiple INNER JOIN query which returns some data I need spread in different tables. This is the query:
B4X:
SELECT [70_Categories].[CategoryID], [70_Categories].[Category], [10_Departments].[DepID], [10_Departments].[DepDescription] , [70_Pictures].[PictureFilename]
FROM (([10_Dep_Pics] INNER JOIN
(([70_Categories] INNER JOIN [80_Dep_Categ] ON [70_Categories].[CategoryID] = [80_Dep_Categ].[CategoryID])
INNER JOIN [10_Departments] ON [80_Dep_Categ].[DepID] = [10_Departments].[DepID])
ON [10_Dep_Pics].[DepID] = [10_Departments].[DepID])
INNER JOIN [70_Pictures] ON [10_Dep_Pics].[PicID] = [70_Pictures].[PicID])
WHERE [70_Categories].[CategoryID] = 1 ORDER BY [10_Departments].[DepID]
Normally one would expect the ColumnNames: CategoryID, Category, DepID, DepDescription, PictureFilename
Instead I get the table names instead of the column names above. Thus:
70_Categories, 70_Categories, 10_Departments, 10_Departments, 70_Pictures
I tested the same query against the database in "DBBrowser for SQLite" and it has the same behaviour.
I googled it and so far I found no solution. Has anyone faced it so far? Any suggestions?
Thanks in advance