Query all chars belonging to 1 account

10/23/2016 14:42 Zetson#1

hey there, please I need a query to display all character names belonging to 1 account . thnx in advance
:):):)

10/23/2016 16:08 B1Q#2

Code:

select * from _Char
LEFT JOIN _User ON _User.CharID=_Char.CharID
LEFT JOIN [SRO_VT_ACCOUNT]..TB_User ON [SRO_VT_ACCOUNT]..TB_User.JID=_User.UserJID
where [SRO_VT_ACCOUNT]..TB_User.StrUserID = 'test'

change SRO_VT_ACCOUNT to your Account Database name
dont forget to change test to your username