To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=113724 Issue #|113724 Summary|Base-SQL with join and multiple records, returns copie |s of first record Component|Database access Version|DEV300m84 Platform|PC URL| OS/Version|Windows XP Status|UNCONFIRMED Status whiteboard| Keywords| Resolution| Issue type|DEFECT Priority|P5 Subcomponent|none Assigned to|dbaneedsconfirm Reported by|eremmel
------- Additional comments from erem...@openoffice.org Sat Aug 7 17:57:39 +0000 2010 ------- Dev300m86 build 9518 I've a two table inner join and when running the query in BASE-SQL mode I get the right number of records, but the data is a copy of the first record returned. This does not happen when running the query in Native-SQL mode. This behavior is when I run the query from SQL and when I use the query in a form. I experienced this with DB Access, but copying the tables and query to HSQLDB showed the same issue. I attach a document with screen shots, because the database contains sensitive data. On request I'll put effort in making a reproduction database. --------------------------------------------------------------------- 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: issues-unsubscr...@dba.openoffice.org For additional commands, e-mail: issues-h...@dba.openoffice.org