Login ProductsSalesSupportDownloadsAbout |
Home » Technical Support » DBISAM Technical Support » Support Forums » DBISAM General » View Thread |
Messages 1 to 3 of 3 total |
UPDATE statement. |
Sat, Dec 9 2006 8:32 AM | Permanent Link |
Abdulaziz Jasser | Could somebody tell me why this UPDATE statement is not working?
UPDATE "MEMORY\tbData" A SET A.Name = B.Name FROM "MEMORY\tbData" A LEFT OUTER JOIN TB_Security B ON B.Symbol = A.Security |
Sat, Dec 9 2006 11:12 AM | Permanent Link |
Abdulaziz Jasser | SOLVED: I lost 3 hours because of this stupid typing mistake.
Regards, Abdulaziz Jasser |
Sat, Dec 9 2006 1:04 PM | Permanent Link |
"Robert" | "Abdulaziz Jasser" <jasser@cyberia.net.sa> wrote in message news:39AD6915-A915-4ABF-BEE8-8C7FCACEB6E6@news.elevatesoft.com... > Could somebody tell me why this UPDATE statement is not working? > > UPDATE "MEMORY\tbData" A SET A.Name = B.Name > FROM "MEMORY\tbData" A > LEFT OUTER JOIN TB_Security B > ON B.Symbol = A.Security > Why in the world use a left outer join for an update like this, where you SET a value to the a value on the joined table? There might be a reason, but it certainly is not obvious. Why do you need access to the rows in A that have no match in B? Robert |
This web page was last updated on Wednesday, April 24, 2024 at 11:07 AM | Privacy PolicySite Map © 2024 Elevate Software, Inc. All Rights Reserved Questions or comments ? E-mail us at info@elevatesoft.com |