here's a simplified case that does not work - it is dumbed-down to have a simple
form that shows the error: invalid use of group function
select ID from tblMembers where count(ID=177)=1
how can i include an "insulated" COUNT within a where clause?
is there a way to make a sub-query?
the actual usage is in the context:
SELECT .... FROM tblA, tblB WHERE tblA.stuff=$C1 AND COUNT( tblB.stuff=$C1 ) =0
tblA and tblB are unrelated, unrelational. i just need them to be within a single query due to the called context of a single shell command.