When the query indicates that it may become more complex or that multiple table JOINS are needed to accomplish the end result, adding the table name to each column of interest is beneficial. For example, the simple query, similar to what was created in Section 1, would look like this:

SELECT

ZVIBERMESSAGE.ZTEXT,

ZVIBERMESSAGE.ZDATE,

ZVIBERMESSAGE.ZSTATE

FROM

ZVIBERMESSAGE

Where ZTEXT, ZDATE, and ZSTATE are the columns and ZVIBERMESSAGE is the table. Each column name is preceded by the table where it is located and is separated by a period.

This information was entered into SQLite Database Browser by selecting the tab, “Execute SQL.”