Topic: Table Grid and multiple SQL Tables.
Hello,
I am trying to fill a TableGrid with a SQL Script. I want to display information from more as one table to the grid.
Something like
Select ID, Date, Company (select id, sum(Badges) from Badgelist) text from Visitors order by Date desc,id descI get an Errormessage:
Error message:
only a single result allowed for a SELECT that is part of an expression
I have not yet done an application, only some changings in an existing application.
.
At the forum I have nothing found if it is possible to display in one table grid information from more as one table.
Table 1: List of companies who are visitors
Table 2: List of visitor badges issued to a company.
Table 3: List of visitors on site.
.
Table grid should show:
Record ID Companyname issued Badges Visitors on site
.
EDIT:
.
Correct display should be:
Record ID Companyname count(issued Badges) count(Visitors on site)
.
The last 2 collums should only show the total count, not detailed information.
test.zip