Re: ANIDATED SELECT
At the moment i have the following:
select s.storename, x.more_than+3
from storeinfo s
join (
select orders.store_id, count(*) as more_than_3
from order_info
join orders on orders.orders_id=orders_info.orders_id
where orders_info.num_items > 3 and orders.timeplaced > current timestamp - 1 day
group by orders.store_id
) x.store_id = s.store_id
Does x.store_id has to be the id of the store in the orders table right?
If so I get the following error message:
object-name IS NOT VALID IN THE CONTEXT WHERE IT IS USED for x.store_id
Any ideas?
Subject
Written By
Posted
Re: ANIDATED SELECT
October 24, 2017 01:52AM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.