The query is almost complete now, but one thing missing is the actual username or any other identifying information about the user instead of the ID assigned to the individual.

Inventorying the possible tables where user data could be contained resulted in the ZMEMBER table being the most likely match. In this table, there is a column for ZNAME that appears to correlate to the desired Username for the query. Now the task becomes matching the ZNAME from this table to the messages in the ZVIBERMESSAGE table using one of the other columns that share a common entry.

It may be easiest to do things by taking into consideration that something like a username or a user phone number would be unique, which would mean that the column that is being used to create a match should contain unique values. In the example above, Z_PK was determined to contain unique values.