Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- -- DROP VIEW MaterialesConBajoNivelEnBodega
- CREATE VIEW MaterialesConBajoNivelEnBodega AS
- SELECT
- ma.nombre AS 'Material',
- bm.stock AS 'Cantidad en Bodegas',
- 'Nombre de Bodega' AS 'Bodegas',
- im.fechaIngreso AS 'Fecha'
- FROM
- materiales ma
- INNER JOIN
- bodegas_materiales bm
- ON ma.idMaterial = bm.idMaterial
- INNER JOIN
- bodegas b
- ON b.codigoBodega = bm.codigoBodega
- INNER JOIN
- (
- SELECT be.codigoBodega, be.direccion AS 'Nombre de Bodega' FROM bodegas_externas be
- UNION
- SELECT bi.codigoBodega, bi.nombreBodega AS 'Nombre de Bodega' FROM bodegas_internas bi
- ) f
- ON f.codigoBodega = b.codigoBodega
- INNER JOIN
- ingresos_materiales im
- ON im.idMaterial = ma.idMaterial
- SELECT * FROM MaterialesConBajoNivelEnBodega
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement