SQLize Online / PHPize Online  /  SQLtest Online

-- Hint: use Ctrl+Enter for SQL autocomplete -- 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), ('Autor2', 2); select b.name, b.code, IsNull(CAST (a.bookCode as nvarchar(100)),'Empty') from books b left join autors_catalog a on b.code = a.bookCode