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:

Things you need

  • OpenOffice Base database

Show MoreHide


  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

  • All types
  • Articles
  • Slideshows
  • Videos
  • Most relevant
  • Most popular
  • Most recent

No articles available

No slideshows available

No videos available

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