I have two MySQL tables, and in a query, I would like to replace the
value of a column from one table with that of a column from another
table. I can't figure out whether this is a join (or what type), or
something else.
For example, if you have two tables:
people: id | name
nicknames: id | nickname
.... and a pseudo-query:
select people.id,
people.name {but instead, return correlating value of
nicknames.nickname},
from people, nicknames
where people.id = nicknames.id;
How do you get the {} stuff?...
Bookmarks