SQLize Online / PHPize Online  /  SQLtest Online

-- Hint: use Ctrl+Enter for SQL autocomplete CREATE TABLE clients ( id INT IDENTITY(1,1) PRIMARY KEY, name varchar(64) ); INSERT INTO clients (name) VALUES ('Client One'), ('Client Two'), ('Client Three'); CREATE TABLE client_phonenumbers ( id INT IDENTITY(1,1) PRIMARY KEY, client_id int, phone_type varchar(64), number varchar(64), FOREIGN KEY (client_id) REFERENCES clients(id) ); INSERT INTO client_phonenumbers (client_id, phone_type, number) VALUES (1, 'home', '+1 (012) 34567'), (1, 'work', '+1 (012) 53219'), (2, 'home', '+1 (012) 26974'); SELECT * FROM clients LEFT JOIN client_phonenumbers ON client_phonenumbers.client_id = clients.id FOR JSON AUTO;