Hi,

I have tried to look for help on this on the net but can't find any.
I got a table that looks like this

tableA.uid_code tableA.str_code tableA.str.name tableA.uid_r_code (this links to uid.code)
1 A Apple 2
2 B Banana 1
3 C Cat 1

How do I do a SELECT query to get all the columns above but for tableA.uid_r_code instead of showing 2,1 and 1, show the str_name that is linked to it, so show Banana, Apple and Apply?

Thanks