eprintid: 670 rev_number: 12 eprint_status: archive userid: 23 dir: disk0/00/00/06/70 datestamp: 2011-05-31 16:48:18 lastmod: 2016-05-27 21:05:24 status_changed: 2011-05-31 16:48:18 type: conference_item metadata_visibility: show item_issues_count: 0 creators_name: Salika, Cathy title: Outer Joins by Example ispublished: pub subjects: voyager divisions: eluna_conf abstract: Outer joins are a technique for dealing with inconsistencies in your data when you write queries. What if some items aren’t barcoded? What if some bibs aren’t indexed by title? What if some items are in temporary locations? Outer joins can also improve your statistics by making sure that odd cases aren’t dropped. In this session, we’ll look at lots of queries that make use of outer joins and see how helpful they can be. date: 2011-05 date_type: published full_text_status: restricted pres_type: lecture event_title: ELUNA 2011 event_location: Milwaukee, Wisconsin event_dates: 11-13 May 2011 event_type: conference refereed: FALSE citation: Salika, Cathy (2011) Outer Joins by Example. In: ELUNA 2011, 11-13 May 2011, Milwaukee, Wisconsin. document_url: https://beta-documents.el-una.org/id/eprint/670/1/Outer_Joins_by_Example-Salika.pdf