James Lowe writes:
> ERROR: Query failed (Unknown table 'disclosure' in where clause)
>
> Is it perhaps because it is an UPDATE?
According to the manual, MySQL 4.1 will have multi-table updates.
A while back Monty stated a target release date. I'm not quite
sure about it, but I think it'll be
Dear Steve:
Thanks for your help. Actually, the table is there. the error reads
ERROR: Query failed (Unknown table 'disclosure' in where clause)
Is it perhaps because it is an UPDATE?
In Paul''s book, he says try the where clause with a select first. The
following works fine.
select fileN
Can someone tell me what I'm doing wrong?
The following SQL gets an error
"Disclosure" table not found
UPDATE patents set patents.clientNumber=disclosure.clientNumber where
patents.disclosureNumber=disclosure.disclosureNumber;
Any help would be appreciated.
Thanks.
Jim Lowe
Patent Attorney
