multiple tables in 1 query without connection beteween tables

[megatronixs]

Hi all,

I started to create a report where I have multiple queries counting the rows with data. Then the main report will have multiple subreports in it.
I was wondering if it was possible to have like 20 tables inside 1 query and each one of the table is one column counted in the query as here below:
field: Pots Counts: Pots
Table: tbl_case_handler_1
Total:Count

(and then the next table on the right like table tbl_case_handler_1 and so on)

Is this possible?

Greetings.

 

[Ranman256]

you CAN have 20 tables in a query.
but if you have 20 tables without joins, it will multiply the records.
not sure why a query needs 20 tables.