To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=48906 Issue #:|48906 Summary:|create view Component:|Database access Version:|680m95 Platform:|PC URL:| OS/Version:|Windows XP Status:|UNCONFIRMED Status whiteboard:| Keywords:| Resolution:| Issue type:|DEFECT Priority:|P3 Subcomponent:|none Assigned to:|msc Reported by:|hannibal
------- Additional comments from [EMAIL PROTECTED] Sun May 8 16:49:33 -0700 2005 ------- I created a view use 3 tables, when I wanted to save the view.... There was a error message. The detail is as following, SQL çæ: S0021 éèç: -27 Column already exists in statement [ SELECT "åæèæè"."ååå", "æçæç è"."å", "æçèæè"."ééåè", "æçèæè"."éèåå", "æçèæè"."æçå å", "æçæçè"."å", "æçèæè"."èçéè", "æçæçè"."å", "åæèæè"."éé åè", "åæèæè"."éååå", "åæèæè"."åæåå", "åæèæè"."çè", "æçæç è"."æ", "åæèæè"."èçéè" FROM "æçèæè" "æçèæè", "æçæçè" "æçæ çè", "åæèæè" "åæèæè" WHERE ( "æçèæè"."æçç" = "æçæçè"."æç ç" AND "åæèæè"."æçèæç" = "æçèæè"."èæç" )] Clearly, the 3 tables are used twice in the auto-created SQL from statement. "æçèæè" "æçèæè", "æçæçè" "æçæçè", "åæèæè" "åæèæè" --------------------------------------------------------------------- Please do not reply to this automatically generated notification from Issue Tracker. Please log onto the website and enter your comments. http://qa.openoffice.org/issue_handling/project_issues.html#notification --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
