The final example above is when attachments are referenced in a database, but they are contained in a table that is different from the table where the message content resides.

In this example, the �_video_id� from the message table is used to locate the file path, �_localPath,� which is stored in a second table, labeled video.

Finding attachments this way requires adding a JOIN statement to an SQLite query.

The �_video_id� from the message table matches the �_id� from the video table, which lists the path to where the original video is stored on the device.