("Select Count(ContestantTender) from PlayTables, PSession Where FKSessionID = SessionID And PlayDate = ? And TimeOfDay = ? "; "" ;"" ; GetAsDate (GetValue ($$Date ; $Counter)) ; $Shift )
returns incorrect results. The count is wrong.
If I leave out Count and just query for ContestantTender, it returns the correct number of results. I can use PatternCount to extract the correct count, but it is slow. Is the select statement incorrect?