mysql sub-selects

[Anon]

I have two tables:

---

| id | title | user |

| 18 | NULL | rik |

-----------------
| id | user |

| 18 | rik |

I want to update the title in the first table, based on the ID in the second table.

UPDATE tbl_1 SET title='somevalue' WHERE user='rik' and id='(SELECT id FROM tbl_2 WHERE user='rik' && tbl_2.id=tbl_1.id)' ;

This update is not happening. Anybody knows why?

Thanks.

Richie.

[Anon]

Gidday Richie.

As per

http://www.mysql.com/doc/A/N/ANSI_diff_Sub-selects.html

MySql currently can't do this kind of sub-select. You have to use some rinkydink LEFT JOIN stuff (which i barely understand).

Regards
Matt