[SQL] three unrelated tables, will count query data with a piece of table data to return-CodePudding

Home > database > [SQL] three unrelated tables, will count query data with a piece of table data to return

[SQL] three unrelated tables, will count query data with a piece of table data to return

Time：09-30

Such as the need to query A table of the count, the count of table B, C table of count
In mysql can

 select * form (

(select count (1) as a from a), 
(select count (1) as b from b), 
(select count (1) as the from c c) 

)

But how to write in PGSQL? Do not use the UNION