cross table update 1

[johnnyasterisk]

UPDATE intellicom.agent_performance ap, pbxware.ql_cache qlc
SET ap.inbcalls = count(qlc.event = 'CONNECT')
WHERE ap.agentid = qlc.type;

the above query give me the following error "Invalid use of group function". However I am not wanting to group by... I am simple wanting to select values in one table and update another. However the value i need to select in the table requires a 'COUNT' to calculate them.

Any help would be appreciated.

Thanks

 

[r937]

However I am not wanting to group by...

oh yes you are wanting to group by

UPDATE intellicom.agent_performance AS ap
INNER
  JOIN ( SELECT type
              , SUM(CASE WHEN event = 'CONNECT'
                         THEN 1 ELSE 0 END) AS connect_count
           FROM pbxware.ql_cache 
         GROUP
             BY type ) AS qlc 
    ON qlc.type = ap.agentid
   SET ap.inbcalls = qlc.connect_count

r937.com | rudy.ca
Buy my new book Simply SQL from Amazon