SQLite Forum

Select and count from 2 tables
Login
I didn't try too hard decoding your pictures, but I note that the expression

```
genre_name = 'Romance' AND genre_name = 'Comedy'
```

will *never* be true. Perhaps you wanted to use `OR` instead? Or simpler:

```
genre_name IN ('Romance','Comedy')
```