I'm trying to get the total count from each table on one row but getting this error
"Old style JOIN (ANSI JOINs) syntax is not allowed. Please use standard syntax."
The SQL query I'm using is below. is there an easy way to achieve this
SELECT (SELECT Count(*) FROM IMPORT_STAGING_DAILYWELCOME_DE) as total_WEL_Stage, (SELECT COUNT(*) FROM SENDABLE_DE) AS TOTAL_Pre_Sent