Sending data to another table

Asked

Viewed 45 times

-3

Hello, I need some help I need to get data using Where to pass to another table : http://image.prntscr.com/image/712077abe80f4033a016675279a7a0dd.png (table of accounts )

In print, shows the " Userid(int) "I need to get all " Userid(int) " using Where

http://image.prntscr.com/image/fc86456e11994997b1d25b8b3480375c.png in this print shows the table where Userid goes

In the Where issue (Where Logincount=3) 2 = offline 3=online

The goal of this is to send items (from the game) to those who are online)

c# sql

  • William what have you tried? Read http://answall.com/help/how-to-ask

1 answer

1


INSERT INTO dbo.WarsEvento (NickName,Status,UserID) SELECT NckName,Status,UserID FROM dbo.Sys_Users_Detail WHERE LoginCount=3

  • Then I can use 2 query in a string ?

  • Yes, they are called sub queries. test and see if that’s what you need

Browser other questions tagged c# sql

You are not signed in. Login or sign up in order to post.