Unanswered: create view query with many select statement.
what I mean is a query like this...
create view monthly AS
select distinct description from item order by description
select sum(quantity-loses) from inventory join item on item.item_id = inventory.item_id where month(date) < month(now())
select sum(quantity-loses) from transaction join item on item.item_id = transaction.item_id where month(date) < month(now());
I already tried to use subqueries but when querying the inventory and transaction table it gives an error "returns more than one row" for they dont have the same where statement.