(HELP) Sql Delete Char without Account

hai.. can someone share code sql for delete character from _Char if without account at TB_User.

because i only delete account at TB_User but not delete character so the char still in SRO_SHARD..

Example for delete account, share from members ragezone :

Code:

---

DELETE FROM TB_User WHERE NOT EXISTS (SELECT * FROM SR_ShardCharNames WHERE SR_ShardCharNames.UserJID=TB_User.JID)

---

ty

if you want to delete from SRO_SHARD the players that do not exist in TB_User. then use this sql query:

DELETE FROM SRO_SHARD WHERE UserJID NOT IN (SELECT JID FROM TB_User);

i do not know the columns names from TB_User and SRO_SHARD but you can change the names in the query.

not work

Msg 208, Level 16, State 1, Line 1
Invalid object name 'SRO_VT_SHARD'.

give me your sql tables structure. the query is fine the names are wrong

just use this query it will clean your shard from chr ^_^"

Quote:

---

Originally Posted by kaydhm

just use this query it will clean your shard from chr ^_^"

---

i need delete character from _Char if without account at TB_User.

no need delete all char

need help

Uppppppppppppppppppppp