Hello there,
I can get the results as I want in my query that I wrote in sql, but when I try to get the same result with x while select, I get the error "join' expected". I will populate my temp table based on my query result.
how can i overcome this problem?
sql query:
select COMPANYID, sum(QUERYCOUNT), sum(QUERYROWCOUNT) from ARCCAMPAIGNQUERYLOG group by COMPANYID, month(QUERYDATE)
x query :
while select CompanyId, sum(QueryCount), sum(QueryRowCount)
from arcCampaignQueryLog
group by CompanyId, mthOfYr(QueryDate)
{
}
