Terceiro, Sql Server

Language: Layout:

--Sql Server 2014 Express Edition
--Batches are separated by 'go'

CREATE TABLE products ( id NUMERIC, name VARCHAR(255), amount NUMERIC, price NUMERIC, id_providers NUMERIC, id_categories NUMERIC )
CREATE TABLE providers ( id NUMERIC, name VARCHAR(255), street VARCHAR(255), city VARCHAR(255), state varCHAR(255) )
CREATE TABLE categories ( id NUMERIC, name VARCHAR(255))

INSERT INTO products ( id, name, amount, price, id_providers, id_categories )
VALUES 
( 1, 'Two-door wardrobe', 100, 800, 6, 8 ),  
( 2, 'Dining table', 1000, 560, 1, 9 ),
( 3, 'Towel holder', 10000, 25, 5, 1 ),
( 4, 'Computer desk', 350, 320, 4, 6 ),
( 5, 'Chair', 3000, 210, 3, 6 ),
( 6, 'Single bed', 750, 460, 1, 2 );

INSERT INTO providers ( id, name, street, city, state )
VALUES 
( 1, 'Henrique', 'AV Brasil', 'Rio de Janeiro', 'RJ' ),  
( 2, 'Marcelo Augusto', 'Rua Imigrantes', 'Belo Horizonte', 'MG' ),
( 3, 'Caroline Silva', 'Av São Paulo', 'Salvador', 'BA' ),
( 4, 'Guilerme Staff', 'Rua Central', 'Porto Alegre', 'RS' ),
( 5, 'Isabela Moraes', 'Av Juiz Grande', 'Curitiba', 'PR' ),
( 6, 'Francisco Accerr', 'Av Paulista', 'São Paulo', 'SP');

INSERT INTO categories ( id, name )
VALUES 
( 1, 'Old Stock'),
( 2, 'New Stock'),
( 3, 'Modern'),
( 4, 'Commercial'),
( 5, 'Recyclable'),
( 6, 'Executive'),
( 7, 'Superior'),
( 8, 'Wood'),
( 9, 'Super Luxury'),
( 10, 'Vintage');
                         
SELECT products.name, providers.name
FROM products
INNER JOIN providers ON providers.id = products.id_providers
WHERE products.id_categories=6;

View schema
Tempo de execução: 0,03 s, linhas selecionadas: 2, linhas afetadas: 22, tempo absoluto de serviço: 0,19 s, tempo absoluto de serviço: 0,2 s