php - Select a value from one of the tables if a value equels a value from the other table -

there 2 mysql tables games_server , orders_order. need select value called full_address first table if value id table equals value server_id of second table orders_order.

but not value. has where service_type = 'be_first' , status = 'running'

i've read possible solutions here , tried that:

select server_address games_server id in     select server_id     orders_order     service_type = 'be_first'       , status = 'running' order updated desc 

but didn't work. i'm not mysql. please out.

select a.thing want select   table want select   join other table b     on b.some column = a.some column  criterion met    , criterion met