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 fileNumber from patents, disclosure where patents.disclosureNumber=disclosure.disclosureNumber; So what am I doing wrong? On 1/3/02 7:17 PM, "Steve Rapaport" <[EMAIL PROTECTED]> wrote: > Maybe it's literally true. It's not finding the "disclosure" > table, which it needs to find the fields disclosure.clientNumber and > disclosure.disclosureNumber. Either you are using the wrong database > or your disclosure table is misspelled or empty. > > -steve > > James Lowe wrote: > >> 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 >> >> >> >> --------------------------------------------------------------------- >> Before posting, please check: >> http://www.mysql.com/manual.php (the manual) >> http://lists.mysql.com/ (the list archive) >> >> To request this thread, e-mail <[EMAIL PROTECTED]> >> To unsubscribe, e-mail <[EMAIL PROTECTED]> >> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php >> >> >> > --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php