Re: [SQL] [SOLVED] UPDATE with WHERE clause on joined table

2006-07-29 Thread Fabian Peters
Am 29.07.2006 um 01:30 schrieb Erik Jones: Fabian Peters wrote: Hi, I'm only very rarely using SQL, so please forgive me if I show any obvious signs of ignorance... I've got three tables "customer", "address" and "country". I want to set the &q

[SQL] UPDATE with WHERE clause on joined table

2006-07-28 Thread Fabian Peters
Hi, I'm only very rarely using SQL, so please forgive me if I show any obvious signs of ignorance... I've got three tables "customer", "address" and "country". I want to set the "language" attribute on "customer" on rows returned by a SELECT such as this: SELECT title, first_names, last