Hi Marcia,

The error doesn't make sense against the query you pasted into the post since there is no table called "data_2" anywhere inside of it.

Is that NGR01_CMH_assay_Genotyping an actual table or is it a query made from a table?

Does the original query work without the INNER JOIN?

Have you tried to rewrite this as a Self JOIN?

https://www.w3schools.com/sql/sql_join_self.asp

Regards,

Jon