Paste this into a new question or an answer at dba.stackexchange.com:
<!-- --> > select version(); > > <pre> > | version() | > | :------------------------------------------ | > | 10.3.11-MariaDB-1:10.3.11+maria~stretch-log | > </pre> <!-- --> > create table tbl1 (name varchar(20)) > > <pre> > ✓ > </pre> <!-- --> > insert into tbl1 values ('n1'),('n2'),('n6') > > <pre> > ✓ > </pre> <!-- --> > create table tbl2 (name varchar(20)) > > <pre> > ✓ > </pre> <!-- --> > insert into tbl2 values ('n1'),('n2'),('n12') > > <pre> > ✓ > </pre> <!-- --> > select name from tbl1 except select name from tbl2 > > <pre> > | name | > | :--- | > | n6 | > </pre> *db<>fiddle [here](https://dbfiddle.uk/?rdbms=mariadb_10.3&fiddle=68b682a4752a39cc49db7ce8f69949e0)*
back to fiddle