How to Join Queries in OpenOffice 3.0

Written by matthew burley
  • Share
  • Tweet
  • Share
  • Email

OpenOffice 3.0 is a productivity suite that is offered as an open source alternative to Microsoft Office. OpenOffice contains a counterpart to most of the Microsoft Office programs, including its database program, Access. OpenOffice Base can perform most of the same functions of Microsoft Access, including query creation. A query is a specialised search of a database, and can be created in Base's query wizard, design view or SQL view. To temporarily combine two tables in a database for a query, you would use SQL's "JOIN" command. From the SQL view, it is possible to use SQL syntax, such as "JOIN," to customise your queries.

Skill level:
Challenging

Other People Are Reading

Things you need

  • OpenOffice Base database

Show MoreHide

Instructions

  1. 1

    Navigate to your OpenOffice Base database, then double-click the file to open it in Base.

  2. 2

    Click the "Queries" option under the "Database" column on the left side of the screen.

  3. 3

    Select the "Create Query in SQL view" option in the "Task" section at the top of the screen.

  4. 4

    Type your "JOIN" query into the window. For example, if you wanted to join a table called "authors" with a table called "members," then compare the "birthdate" field in each table, the "JOIN" query would look like:

    SELECT *

    FROM authors

    INNER JOIN members

    ON authors.birthdate = members.birthdate;

  5. 5

    Click the "SQL" button on the toolbar to execute your SQL "JOIN" query.

Tips and warnings

  • The Query wizard that is included with OpenOffice Base can be useful for most common query commands. If you are unfamiliar with SQL syntax or want to create a query in a simpler manner, consider using the wizard instead of the SQL Design view.

Don't Miss

Filter:
  • All types
  • Articles
  • Slideshows
  • Videos
Sort:
  • Most relevant
  • Most popular
  • Most recent

No articles available

No slideshows available

No videos available

By using the eHow.co.uk site, you consent to the use of cookies. For more information, please see our Cookie policy.