How to select records from multiple sqlite tables?

Question

Python

How to select records from multiple sqlite tables?

Answer 1

And what exactly are the difficulties?
Regular SQL queries like:

SELECT t1.field1, t2.field2 FROM first_table AS t1 LEFT JOIN second_table AS t2 ON t1.some_field=t2.some_field

Answer 2

Everything works except:
Both tasks are solved through LEFT OUTER JOIN if necessary.