To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=96330 Issue #|96330 Summary|creating left/right queries user experience Component|Database access Version|OOo 3.0 Platform|All URL| OS/Version|All Status|UNCONFIRMED Status whiteboard| Keywords| Resolution| Issue type|ENHANCEMENT Priority|P3 Subcomponent|none Assigned to|dbaneedsconfirm Reported by|atjensen
------- Additional comments from [EMAIL PROTECTED] Wed Nov 19 03:17:03 +0000 2008 ------- The result set produced by Left or Right joins is influenced by which direction one moves the mouse during the selection of columns to join on. IMO this leads to confusion on the part of some users, particularly less experienced users that are not confident in their knowledge of SQL. Open the attached odb file - run the 4 queries and look at each in the query designer. The queries have names that designated both the type of JOIN and which direction the mouse was dragged when the join was created. ie. qry_left_join_L2R = a left join created by dragging the linked column from the table on the left to the table on the right with the mouse. Open the attached odg file for the pretty pictures.. Honestly I think this is actually a usability defect, but RFE is good also. Possible changes: 1) None - it works just fine the way it is. 2) The drag direction should make no difference - Which table is on which side of the join should be based solely on the placement of the table objects in the query designer. 3) Some change to the UI, when the "Join Properties" dialog is not displayed so that the user both knows which table is on the which 'side' of the join and what type of join is being represented. ( perhaps I am mixing something new in the last section of this option? ) Others ?? --------------------------------------------------------------------- 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]