REPLACE INTO over mulitple tables

[sfullman]

This si for mysql 4.0+.

I have used REPLACE INTO before, but can I do this on a join between two tables, e.g.:

replace into table1, table2 WHERE table1.primary=table2.foreign SET field1='value', field2='value2', etc.

Thanks!

[tekky]

Have you tried it?