The mistake made in an SQLite query that tries to reference a column in a table which is a record in another table is that the column is not directly accessible. This is because the record in the other table is stored as a foreign key in the first table as a reference to its primary key. Therefore, to access the column in the table that is referenced by the foreign key, a join operation between the two tables must be used.
