Hi,
I have something like this
select A, B, C
from tableA
where A = '123'
group by B
and the results include entries whose A is not '123'. Why is this not the results I expected it to be?
thanks
database has 16k entries
actual result (7k entries): a mixture of entries with A='123' and A='other'
expected results (5k entries): all entries with A='123'