Differences

This shows you the differences between two versions of the page.

Link to this comparison view

Both sides previous revision Previous revision
vendors:cisco:uc:ece:sql [2024/06/28 18:36] – [Number of chats sent / receipts per chat conversation (activityId)] gerardorourkevendors:cisco:uc:ece:sql [2024/12/05 08:55] (current) – [SQL User <> CCE Mapping] gerardorourke
Line 613: Line 613:
 SELECT * SELECT *
 FROM EGICM_USER FROM EGICM_USER
-    RIGHT OUTER JOIN EGPL_USER ON EGPL_USER.user_id = EGICM_USER.user_id+    LEFT JOIN EGPL_USER ON EGPL_USER.user_id = EGICM_USER.user_id 
 +     
 +ORDER BY FIRST_NAME, LAST_NAME
 </code> </code>
  • vendors/cisco/uc/ece/sql.1719596204.txt.gz
  • Last modified: 2024/06/28 18:36
  • by gerardorourke