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