Im in a bit of a muddle trying to join two tables. As an example I have the following two tables and need to join the second table onto 2 fields on the first table:
name, place1, place2
Andy 1 2
Mark 3 1
I want to select all in the main_dat table and output:
Andy First Second
Mark Third First
Can anyone point me in the right direction with this? Thanks.