Consolidating two tables with repeating results

When you want implement a cartesian product you must use CROSS JOIN statement

Try this:

SELECT table1.module, table2.townFROM table1CROSS JOIN table2

You can see here about JOINs operation in SQLite

CodeHunter