错误1052:where子句中的“metric\u name”列不明确

9vw9lbht  于 2021-06-21  发布在  Mysql
关注(0)|答案(1)|浏览(238)
SELECT b.target_host                              AS 'host',
       a.target_ip                                AS 'Target',
       a.monitor_type                             AS 'Type Monitor',
       Concat (a.metric_name, "", a.metric_value) AS "metric name value"
FROM   pm_sis_raw_metrics AS a
       INNER JOIN pm_sis_hs_metrics AS b
               ON a.id = b.id
WHERE  metric_value > 80
       AND ( metric_name = "utilization"
              OR metric_name = "physical memory used %"
              OR metric_name = "disk/file system/[c]/percent full"
              OR metric_name = "% packets good" )

错误1052:where子句中的“metric\u name”列不明确

yftpprvb

yftpprvb1#

必须使用列名指定表别名,如where cause中的.metric\u name。

相关问题