Query all chars belonging to 1 account

[Zetson]

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

[B1Q]

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