SQLite Forum

select match though row does not exists
Login
Chronological Hierarchical 
Changing your schema is highly unlikely to fix your broken C code; neither is describing your code as opposed to posting the parts that don't work.