SQLize Online / PHPize Online  /  SQLtest Online

-- Hint: use Ctrl+Enter for SQL autocomplete create table books ( code int, name nvarchar(100) ); insert into books (code,name) values (1, 'BookWithAutor'),(3, 'BookWithoutAutor'); create table autors_catalog ( name nvarchar(100), bookCode int); insert into autors_catalog values ('Autor1', 1),('Autor1', 2); select b.name, b.code, IsNull(CAST (a.bookCode as nvarchar(100)),'Empty') as AutorCode from books b left join autors_catalog a on b.code = a.bookCode