On 01-01-16 13:08, Don Parris wrote:
Hi all, I have a set of tables for contacts, and a somewhat complex query that seeks all the available contact information on a subset of the contacts. By "incomplete result set", I mean I have one contact that does not show up in the query results, but should. I know why: that contact has phone and e-mail information, but does not yet have a record in the address table. Everyone else who has an address record in the address table shows up in the results. I would like to see what information *is* available (regardless of whether or not there is an address record (or even if there is an address, but no phone/email information). I am fairly sure I need to change the join type (using LEFT or RIGHT) on the relevant table(s), just not sure how exactly. My current query is (built in Design View, copied from SQL View):
In design mode, right-click on the link between two tables, and click 'edit'...
If you want to manually edit the SQL, the syntax is shown here: https://help.libreoffice.org/Common/Special_Settings#Use_Outer_Join_syntax_.27.7BOJ_.7D.27 -- To unsubscribe e-mail to: [email protected] Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
