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.