sqlite get matching rows from two tables code example

Example: sqlite get matching rows from two tables

SELECT column1, column2,..., columnn

FROM table-list

[WHERE condition]

 

INTERSECT

 

SELECT column1, column2,..., columnn

FROM table-list

[WHERE condition];