Select Count(a.PK) as q1, Count(b.PK) as q2
From Table1 as a, Table2 as b

Select Count(a.PK) as q1, Count(b.PK) as q2
From Table1 as a CROSSJOIN Table2 as b

SELECT
    dt2.q1,
    dt3.q2
FROM
    (SELECT 1) dt1(n)
    CROSS APPLY (SELECT COUNT(*) FROM dbo.Customers) dt2(q1)
    CROSS APPLY (SELECT COUNT(*) FROM dbo.Input) dt3(q2);

SELECT q1, q2 FROM
(SELECT Count(a.PK) as q1 FROM Table1 as a) t1, 
(SELECT Count(b.PK) as q2 FROM Table2 as b) t2

We walk in the dark places no others will enter
We stand on the bridge and no one may pass

SELECT q1, q2 FROM
(SELECT Count(a.PK) as q1 FROM Table1 as a) t1 CROSS JOIN
(SELECT Count(b.PK) as q2 FROM Table2 as b) t2

We walk in the dark places no others will enter
We stand on the bridge and no one may pass

(SELECT 1) dt1(n)
    CROSS APPLY (SELECT COUNT(*) FROM dbo.Customers) dt2(q1)
    CROSS APPLY (SELECT COUNT(*) FROM dbo.Input) dt3(q2);

select 
	Count1 = (select COUNT(*) from #Table1),
	Count2 = (select COUNT(*) from #Table2)

DECLARE @Table1 TABLE (PK INT, Name VARCHAR(6))

INSERT INTO @Table1 SELECT 1, 'XXXXXX' UNION ALL SELECT 2, 'XXXXXX'

DECLARE @Table2 TABLE (PK INT, Name VARCHAR(6))

INSERT INTO @Table2 
SELECT 1, 'XXXXXX' UNION ALL SELECT 2, 'XXXXXX' UNION ALL SELECT 3, 'XXXXXX'

SELECT [From Table 1]=COUNT(PK1), [From Table 1]=COUNT(PK2) 
FROM (
    SELECT PK, NULL FROM @Table1 
    UNION ALL 
    SELECT NULL,PK FROM @Table2) a(PK1, PK2)