SQLite IN (Select Example

CREATE TABLE results AS SELECT * FROM loganalysis
WHERE bookingnumber
IN (SELECT bookingnumber FROM advisoryitems GROUP BY bookingnumber)