Quick questions, are you using SQLite or SQL Server? Can you post the DDL (create table ) scripts for the relevant tables, sample data as an insert statement and the expected results. Alternatively to the DDL you could post the .sqlite file in a zipped format although if you are on SQLite then you might not get too much input on this SQL Server forum.

😎