photo

Martin Roy

shared this question
2 years ago

Statistics

0
Comments
171
Views

Relates to

Share

1
votes

how to delete inactive agents in one swoop the right way?

I tried below but it did not remove the 11000 inactive agents

  1. DELETE UDB, UDBE
  2. FROM default_en_userdb as UDB
  3. INNER JOIN default_en_userdbelements as UDBE ON UDB.userdb_id = UDBE.userdb_id
  4. WHERE UDB.userdb_is_agent = 'yes'
  5. AND UDB.userdb_active ='no';

Leave Comment

photo

Attach files...

The file must be a jpg, gif, png, bmp, ico, pdf, doc, rtf, txt, zip or rar no more than 20M