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:
Other People Are Reading
Things you need
- OpenOffice Base database
Navigate to your OpenOffice Base database, then double-click the file to open it in Base.
Click the "Queries" option under the "Database" column on the left side of the screen.
Select the "Create Query in SQL view" option in the "Task" section at the top of the screen.
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:
INNER JOIN members
ON authors.birthdate = members.birthdate;
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.
- 20 of the funniest online reviews ever
- 14 Biggest lies people tell in online dating sites
- Hilarious things Google thinks you're trying to search for