Query Gm acc + Chra ID

Hello,
as the title say i need a query to get ChraID + all Gm Account in my DB,i try look in google match and i cant found any,waiting help ppl plz :).

UPppppppppppppppppppppppppp

upppppppppppppppppppppppppppppp help omg ?

I hate sql. Hope this help you out
[Only registered and activated users can see links. Click Here To Register...]

thank you snowstorm,but i need to get CharID by chra name not chra name by CharID,hope you help again thanks match.

USE [SRO_VT_SHARD]

Select CHARID from _Char where CharName16 like '%%%%%'

Thanks all for help Respect

this will help you :)

Quote:

SELECT _Char.CharName16 , TB_User.StrUserID , TB_User.sec_content , TB_User.sec_primary FROM FEAR_VT_SHARD.dbo._User INNER JOIN FEAR_VT_SHARD.dbo._Char ON _User.CharID = _Char.CharID INNER JOIN FEAR_VT_ACCOUNT.dbo.TB_User ON _User.UserJID = TB_User.JID where sec_primary =1