Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- CREATE VIEW VistaProveedores
- AS
- SELECT p.nombreProveedor AS 'Nombre de Proveedor', p.direccion AS ' Dirección', t.numero AS 'Teléfono' FROM proveedores p
- INNER JOIN telefonos_proveedores t ON p.idProveedor = t.idProveedor
- SELECT * FROM VistaProveedores
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement