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
#x27;SPAIN'; That is, I want to set the "language" to 'Spanish' where the "customer.email" is like '%.es' and where "country.country_name" is 'SPAIN'. I've tried all sorts of places to put the JOIN and the WHERE clauses

[SQL] transaction block causing trouble

2004-02-20 Thread Fabian
d. my file can be found gzipped at http://www.cwi.nl/~fabian/test.sql.gz Any help is appreciated for I'm clueless about this issue :) ---(end of broadcast)--- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]