need help in query delete

Hello i will delete accounts without chars from my database

i was minding and wrote this code but it dont will work anyone can help me and reedit my code pls

USE SRO_VT_ACCOUNT
DELETE FROM TB_User
WHERE JID NOT EXISTS IN SRO_VT_SHARD_INIT.dbo._Char

:(

The JID from _User has no meaning within the _Char table, the only IDs is the one when the character gets initialized. You have to check 1-2 further tables linking them each other and figuring out which account does not inherit any kind of information character wise.

i wrote JID

can u reedit mine ?

Quote:

Originally Posted by Devel37 i wrote JID can u reedit mine ?

what you even mean, delete accounts without chars?

you mean, u want to delete the "Characters"
but leave the same "Username" ?
he can login but he found his account " EMPTY NO CHARACTER FOUND "
IS THAT U MEAN?
IF THAT U MEAN, SIMPLE CLEAN "SRO_VT_ACCOUNT"

DELETE FROM TB_User
WHERE JID NOT EXISTS IN (SELECT JID FROM SRO_VT_SHARD.dbo._Users)

replace columns with the correct name, i dont have a sql server setup yet... (updating to SQL Server 2016)