SQLite Forum

joining tables on multiple conditions; how to do it when second table lacks some rows?
> I hope I could make my problem clear.

An actual SQL schema and some sample data would make it about 1000x clearer.

> "Show me your flowcharts and conceal your tables, and I shall continue to be mystified. Show me your tables, and I won't usually need your flowcharts; they'll be obvious." -- Fred Brooks.