[request] Query add silk by guild name.

[TEVEZ_7]

as a title said I need a query to add silk to guild members by guild name I searched and tried to make it by self but failed.
so i'm sure here I can found who can make it .
thx in adv.

Edit

this one work well

 Spoiler

declare @ int = 100
declare @ varchar(64) = 'VSRO'
update SRO_VT_ACCOUNT..SK_Silk set silk_own += @ from SRO_VT_ACCOUNT..SK_Silk s
inner join SRO_VT_SHARD.._User u on u.UserJID = s.JID
inner join SRO_VT_SHARD.._GuildMember g on g.CharID = u.CharID
inner join SRO_VT_SHARD.._Guild gj on gj.ID = g.GuildID where gj.Name = @

special thanks to @

[Devsome]

Show us your tries, so we can help you

[sonzenbi]

I think this will work

 Spoiler

declare @ int = 100
declare @ varchar(64) = 'VSRO'
update SRO_VT_ACCOUNT..SK_Silk set silk_own += @ from SRO_VT_ACCOUNT..SK_Silk s
inner join SRO_VT_SHARD.._User u on u.UserJID = s.JID
inner join SRO_VT_SHARD.._GuildMember g on g.CharID = u.CharID
inner join SRO_VT_SHARD.._Guild gj on gj.ID = g.GuildID where gj.Name = @

[TEVEZ_7]

Originally Posted by sonzenbi

I think this will work

 Spoiler

declare @ int = 100
declare @ varchar(64) = 'VSRO'
update SRO_VT_ACCOUNT..SK_Silk set silk_own += @ from SRO_VT_ACCOUNT..SK_Silk s
inner join SRO_VT_SHARD.._User u on u.UserJID = s.JID
inner join SRO_VT_SHARD.._GuildMember g on g.CharID = u.CharID
inner join SRO_VT_SHARD.._Guild gj on gj.ID = g.GuildID where gj.Name = @

that is it I was miss a small thing thank you !