hi, im trying to write a mysql query to join tables.
I basically i have the following tables:
tblwinners = table that shows all the winners PK reward_id customer_id
tbluser = table that holds all the user accounts PK customer_id
tblcompleterewards = completed rewards PK reward_id
tblrewards = holds a list of rewards PK reward_id
I need to output on the winners page a winner which will be in the tblwinners table as a row
Ok I am trying to (select) the username from the tbluser table and select the title from the tblrewards table but ensuring that the rewards_id matches between each table. how can I write a query for me to do this?