java - Capture values from JDBC requests and use for next query -

i'm trying use jmeter 10 queries per thread. want each thread insert player table using mysql auto increment. want use mysql

select last_insert_id(); 

to grab auto inc value , use next query inserted player_game table.
how store value returned , how call in next query?
tried save in variable name can't seem insert correctly on next query.

i tried call using both ${player1id} , player1id couldn't work.

is there better way go this?
or how can store value next jdbc request?

both queries

insert player... insert player_game... 

have auto increment on player_id , player_game_id need insert third table player_game_round , need insert values both player_id , player_game_id such:

insert player_game_round (round, player_score, player_id, player_game_id).... 

you can directly

insert player_game(player_id, game_id) values(last_insert_id(), 1);