CREATE VIEW DetWareShip AS
	select d.product_id as [ID детали],
			d.name as [Наименование детали],
			d.product_type as [Тип детали],
			w.warehouse_id as [Хранится на складе №],
			w.quantity_in_stock as [Остаток на складе],
			w.last_operation as [Дата последней операции с деталью] ,
			s.buyers_code as [Код покупателя],
			s.warehouse_id as [Куплено со склада №],
			s.number as Количество,
			s.unit as [Ед.изм.],
			s.shipping_date as [Дата отгрузки]
from details d
join warehouse w on w.product_id=d.product_id
join shipment s on s.code_product=d.product_id and s.warehouse_id=w.warehouse_id
where w.last_operation>=ALL(select last_operation from warehouse where warehouse.product_id = d.product_id)