I have two tables.
The one is named "member".
The other is name "test".
The table "member" has two fields.
They are named (ID) and [name] each.
The (ID) is the primary key.
And the following is the list of its values.
(1) [Tom]
(2) [John]
The table "test" also has two fields.
They are named(ID) and [memberID].
The (ID) is also the primary key.
And the following is the list of its values.
(1) [1]
(2) [2]
(3) [1]
Let's look at the next query and the output.
select ID, memberID
from test
The outputing of the above query will be the following.
(1) [1]
(2) [2]
(3) [1]
Now I want to output the following.
(1) [Tom]
(2) [John]
(3) [Tom]
Suggestion please!
