SQLite Forum

Select and count from 2 tables
Login
Note that you can sprinkle semantic sugar on top if you like:

```
   select movie_id 
     from genremap
     join genres 
       on genremap.genre_id == genres.genre_id 
    where genre_name == 'Romance'
INTERSECT
   select movie_id
     from genremap
     join genres
       on genremap.genre_id == genres.genre_id 
    where genre_name == 'Comedy'
;
```

or perhaps even

```
   select movie_id 
     from genremap 
     join genres 
    using (genre_id)
    where genre_name == 'Romance'
INTERSECT
   select movie_id
     from genremap 
     join genres
    using (genre_id)
    where genre_name == 'Comedy'
;
```
or

```
   select movie_id 
     from genremap natural join genres 
    where genre_name == 'Romance'
INTERSECT
   select movie_id
     from genremap natural join genres
    where genre_name == 'Comedy'
;
```