To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=93562 Issue #|93562 Summary|Left/Right Join Bug Component|Database access Version|OOo 3.0 RC1 Platform|PC URL| OS/Version|Windows Vista Status|UNCONFIRMED Status whiteboard| Keywords| Resolution| Issue type|DEFECT Priority|P3 Subcomponent|none Assigned to|dbaneedsconfirm Reported by|toml_12953
------- Additional comments from [EMAIL PROTECTED] Sun Sep 7 11:21:18 +0000 2008 ------- I'm trying to create a query in Base 3.0. I have a Customer Table and an Orders Table. Customer Table has a Primary Key, CustID, Orders has the foreign key CustID and a Primary Key of OrderNo. In the query, I drag the CustID key in one table to the other to create the relationship. I can't seem to make Left Join and Right Join be different. Both only give the option to show all records from whichever table I started the drag from. Example: If I click on CustID in the Orders table then drag over to CustID in the Customers table, both Left and Right Join only give me the option to see all records from the Customer table and only those Orders records that match. This is not correct. One join type should give me that option and the other join type should give me the option to see all Orders records and only those records in the Customers table that match. --------------------------------------------------------------------- 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]