Access to the ID number (to be automatic), record Numbers of two tables-CodePudding

Home > database > Access to the ID number (to be automatic), record Numbers of two tables

Access to the ID number (to be automatic), record Numbers of two tables

Time：10-04

 SELECT SUM (COUNT (HR. ID), COUNT (HRWX. ID)) AS a total 
The FROM HR, HRWX;

Running tips for function parameters in the right number in the query expression 'SUM (COUNT (HR. ID), COUNT (HRWX. ID))'

CodePudding user response:

SELECT COUNT (1) the FROM (
SELECT the ID FROM HR
UNION ALL
SELECT the ID FROM HRWX) AA