Search results

u have 6 colums player ID first name last name the other fiedls are numbers that i want to comebine is there a query that will add everything to one row for that player ID

ok I have a union Query on my sessions so i can use them all at once now i want to run the quary against the list of players but combine all the data or add it all together instead of each player having mulitple sessions in my query view i want everything totaled up on each player is...

it asked me to save my import steps so i could reuse them How do i do this i am importing CSV files all have the same colume names but i dont want to have to name all columes on each import But dont understand how to use the saved import steps

i guess my question is how do i combine the 10 tables into one so i can query off that insted of 10 seperate tables

its works like this but when i add another session it goes back to blank SELECT dbo_PlayerDay.PlayerId, dbo_PlayerDay.TripNumber, dbo_Machine_PM.Mnum, dbo_PlayerSession0.Location, dbo_Machine_PM.MFR FROM (dbo_PlayerSession0 INNER JOIN dbo_Machine_PM ON dbo_PlayerSession0.Mnum =...

I have 10 tables with data they are all player session tables I have a list of games i want to compair against 144 games the 10 tables have multiple data entries for each game and player I need to get player data broken down by machine and points on the machine when i try this query it...

Cool yeah i just ran a query on that query and it worked fine

Awesome it worked Thanks million Now i need to add another colum of play to that query should i just save the query and import it back in as a table and re run the query or is there another way?

I have a table with 500+ records I want to add a colum of play but not every record will have play I just want those players to remain blank and i want it to enter play for the ones that have matches to the other table this is what i am using but it removes everyone without play SELECT...