I am used to use the
The select a.f _groupid, a.f _groupname, count (distinct d.f _cardno) as cc
The from t_b_group a, t_b_consumer b, t_b_idcard c, t_d_cardrecord d
Where a.f _groupid=b. _groupid
And b. _consumerid=c.f _consumerid
And c.f _cardno=d.f _cardno
Group by a.f _groupid, a.f _groupname
Query everything is normal, but always prompt in PB
Syntax error loss (operator) in the query expression 'count (distinct d.f _cardno)',
What reason be? Have similar function substitute?

CodePudding user response:

PB a few ah, try on my side, there is no problem oh, this code look familiar, ha ha

CodePudding user response:

The consumption of one cartoon?
Grammar do not have what problem!