mm2000
public sql v1 · immutableSELECT t1.a, t1.b, t1.c, COUNT( t2. * ) AS dFROM table t1LEFT JOIN table t2 ON t1.b = t2.cWHERE t1.b = 'foobar'SELECT t1.a, t1.b, t1.c, COUNT( t2. * ) AS dFROM table t1LEFT JOIN table t2 ON t1.b = t2.cWHERE t1.b = 'foobar'