Question: How can I select count(\*) from two different tables (table1 and table2) having as result:

```
Count_1   Count_2
123       456

```

I've tried this:

```
select count(*) as Count_1 from table1 
UNION select count(*) as Count_2 from table2;

```

But here's what I get:

```
Count_1
123
456

```

I can see a solution for Oracle and SQL server here, but either syntax doesn't work for MS Access (I am using Access 2013).
[Select count(\*) from multiple tables](https://stackoverflow.com/q/606234/5556320)

I would prefer to do this using SQL (because I am developing my query dynamically within VBA).

Answer: 
Cross join two subqueries which return the separate counts:

```sql
SELECT sub1.Count_1, sub2.Count_2
FROM
    (SELECT Count(*) AS Count_1 FROM table1) AS sub1,
    (SELECT Count(*) AS Count_2 FROM table2) AS sub2;

```
Is a SUM (or AVG) like this what you are trying to achieve?

```
select sum(count) from (
select count(*) as Count from table1 
UNION select count(*) as Count from table2
);

```