Problem i

[Rasmus]

I get the following error:

"Unknown table 'tabel_b' in where clause", when I try to run the following
SQL in phpMyAdmin:

UPDATE table_a
SET table_a.value = 'text'
WHERE table_a.number = table_b.number
AND table_b.id = 1234

Could anyone please help me out? Thanks :)

[w w]

On Sat, 01 Nov 2003 12:53:20 +0000, Rasmus wrote:

I get the following error:

"Unknown table 'tabel_b' in where clause", when I try to run the following
SQL in phpMyAdmin:

UPDATE table_a
SET table_a.value = 'text'
WHERE table_a.number = table_b.number
AND table_b.id = 1234

Could anyone please help me out? Thanks :)

How can you get an error for 'tabel_b' when you only make mention to a
'table_b' in your SQL. I assume tabel is a typo. Perhaps there is no
table_b, or maybe tabel_b.

Good luck.

-w w