我想在子查询的帮助下将它们连接起来。我该怎么做呢?------------------UOF
( FROM dw_UtilizationPredictionReportSUM(AvailableHrs) AHRS, SUM(BilledFTE) AS OffBFTE
FROM dw_UtilizationPredictionReportDI
我正在像这样对我的stats表运行这个查询。SELECT day, (SELECT COUNT(*) FROM stats WHERE DAYOFMONTH( stats.timestamp ) = DW.day_id AND MONTH( stats.timestamp) AND YEAR( stats.timestamp ) = YEAR(CURDATE()) AND stats.user_id = 1) AS taly FROM daysoffthemonth DW这是我从那个查询中得到的输出。注释中