I think you need a new approach. It appears that update does not support the join you are attempting. It seems that you are trying to update the value for a column from one table with the value of a column from another table. If this is the case, i would use a shell script to first extract the values from tblSNLC and then update them directly into the tblSNOrg > Kevin thanks for your response. Here are the different errors for each SQl > command I enter. > > Command: update tblSNLC,tblSNOrg set > tblSNOrg.OrgSponsor1=tblSNLC.SponsorFull where tblSNOrg.OrgZip=tblSNLC.Zip; > > Error: Failed to execute SQL : SQL update tblSNLC,tblSNOrg set > tblSNOrg.OrgSponsor1=tblSNLC.SponsorFull where tblSNOrg.OrgZip=tblSNLC.Zip; > failed : You have an error in your SQL syntax near 'tblSNOrg set > tblSNOrg.OrgSponsor1=tblSNLC.SponsorFull where tblSNOrg.OrgZip=tblS' at line > 1 > > Command: update tblSNLC,tblSNOrg set OrgSponsor1=SponsorFull where > OrgZip=Zip; > > Error: Failed to execute SQL : SQL update tblSNLC,tblSNOrg set > OrgSponsor1=SponsorFull where OrgZip=Zip; failed : You have an error in your > SQL syntax near 'tblSNOrg set OrgSponsor1=SponsorFull where OrgZip=Zip' at > line 1 > > > THIS NEXT ONE SEEMS THE CLOSEST > Command: update tblSNOrg set OrgSponsor1=tblSNLC.SponsorFull where > OrgZip=tblSNLC.Zip; > > Error: > Failed to execute SQL : SQL update tblSNOrg set > OrgSponsor1=tblSNLC.SponsorFull where OrgZip=tblSNLC.Zip; failed : Unknown > table 'tblSNLC' in field list > > I don't know why it wouldn't find the table.... > > Thanks for any continued help. > > -eric > > > > > On 9/12/2001 10:46 AM, "Kevin Kotun" <[EMAIL PROTECTED]> wrote: > > > > > > > I obviously dont know what the error message is but > > > > Update tbl1, tbl2 set tbl1.CategoryInTable1 = tbl2.CategoryInTable 2 where > > ^ > > | > > This space may be a problem > > > > good luck, > > > > try to provide the error message > > > > -- kevin > > > > --------------------------------------------------------------------- > > 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 > > --------------------------------------------------------------------- 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
