To comment on the following update, log in, then open the issue:
http://www.openoffice.org/issues/show_bug.cgi?id=108079
User oj changed the following:
What |Old value |New value
================================================================================
Assigned to|oj |msc
--------------------------------------------------------------------------------
------- Additional comments from o...@openoffice.org Wed May 12 11:05:27 +0000
2010 -------
The problem is the order in which you drop fields from table to another.
When looking at the sample you see that when changing to left join the current
version of hsqldb doesn't support the functionality to access table fields which
are in a nested join. For example Access creates the same SQL statement as we do
now. And other databases supports the nested feature as well. E.g. MySQL
To make the statement do what you want to you have to delete the joins and
create them again. But you have to take care that the "time stamps" table is on
the left side.
@msc: Please verify. Thanks
- Open sample
- Edit query and delete joins
- Create new joins and take for that "time stamps" is on the left side when you
double click the connection
- Choose left join
=> Execute
---------------------------------------------------------------------
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
