I've got a data set on which I'm trying to perform the same as excel's
vlookup formula using SQL, but do not know how. Can anyone help?
If you picture me having two tables Table_A and Table_B and they look
like this;
Table_A
Name Sport
John Football
John Rugby
Steve Cycling
Steve Running
Table_B
Name Age
John 23
Steve 24
Peter 25
How do I extract All from Table_B and one Sport from Table_A
I.E I want to end up with something like this...
Name Age Sport
John 23 Football
Steve 24 Cycling
Peter 25 NULL
Thanks in advance,
Ciarán