MySQL Table Results to Process Another Table Results

[PeejAvery]

It works, but using nested SQL statements would be more efficient (less resources on the server and faster results).

SELECT * FROM qpons WHERE id = (SELECT qpon_id FROM participation WHERE shop_id = '{$session->user_id}')