Re: UPDATE SQL statement

2002-01-03 Thread James Lowe
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 wh

Re: UPDATE SQL statement

2002-01-03 Thread James Lowe
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