Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Recent content by gamingmouse

  1. gamingmouse

    Using IN operator with a sub-query

    What if the Select statement is a saved Query. That is, it does not work if I save SELECT id FROM my_table WHERE x = 1; as MyQuery and then try to do: SELECT * FROM my_table WHERE id IN (MyQuery);
  2. gamingmouse

    Using IN operator with a sub-query

    I'm familiar with SELECT * FROM my_table WHERE id IN (2,4,8) But how can I do something like this: SELECT * FROM my_table WHERE id IN ( SELECT * FROM my_table WHERE x = 1 ); Please IGNORE that the subquery in the above example is totally unneeded. This is a purely snyntactical...
  3. gamingmouse

    "Enter Parameter Value" Error In Simple Query (MS Access)

    Yes. Thank you. Also, if I am interested ONLY in games in which I was one of the players, how could I do this? Each row also has a "player_id" field -- and for each group of "game_id" every "player_id" is unique. The problem is that I cannot simply add "WHERE player_id = 12" because...
  4. gamingmouse

    "Enter Parameter Value" Error In Simple Query (MS Access)

    The "game_players" table contains poker data. Each "game_id" is repeated for as many players happened to be in that game, or hand. If a player saw the flop, then the field "saw_flop_n" = 1; if not, it equals 0. I'm trying to get all game_id in which exactly two players saw the flop: SELECT...
  5. gamingmouse

    Complex (?) Query Question

    Golom, Thanks again. I have now adapted your code to the actual table, which has a couple idiosyncrasies, and I am getting a strange result. SELECT Avg(BS.total_won - BS.total_bet) AS [Avg Won], BS.hole_cards AS [Hole Cards], count(*) AS [Sample Size] FROM [SELECT * FROM game_players AS GP...
  6. gamingmouse

    Complex (?) Query Question

    Golom, Thank you very much. I hope you can help with another quick one.... Two other columns in that table are "total_won" and "hole_cards". The following query will select display the hole cards and the amount won for all steal attempts made on the button: SELECT GP.total_won, GP.hole_cards...
  7. gamingmouse

    Complex (?) Query Question

    My database contains poker data with the following relevant colums (I've included sample data): game_id player_id number_of_players pf_raise saw_flop 21 2 4 0 1 21 8 4 0 1 21 372 4 0 0...
See more

Part and Inventory Search

Back
Top