MYSQL Join help

[anonymous]

Hey guys,

Putting it simply, here is my situation
I have one table with records like this:

+--------+------+------+
| index | name | style|
+--------+------+------+
| 1 | 7 | 110 |
| 2 | 23 | 343 |
| 3 | 6 | 443 |
| 4 | 7 | 441 |
| 5 | 23 | 210 |
+--------+------+------+

I then have another table like this

+--------+------+------+
| index | data | type |
+--------+------+------+
| 7 | asdf | ASF |
| 23 | qwer | ASF |
| 110 | fkgk | FHH |
| 441 | fkgj | FHH |
| 6 | ksdk | ZAD |
+--------+------+------+

All i need to do is switch the name and style number values in colums "name, style" in the first table for the "data"
column in the second table. Based on the Index in the second table.

So if name column's value was 23, when i do my select query it would retun "qwer"
instead of 23

Can ANYONE please help please?

[Markus Popp]

Hi,

This should be what you're looking for (pretending, you want ALL rows from
the first table, whether or not there are matching rows in the second table;
if you only want matching rows, replace 'left join' by 'inner join'):

select a.index, b.name, a.style, b.type
from table1 a left join table2 b on a.name = b.index

Markus