So I am new to SQL and I have a project that I am trying to accomplish. I am using a read only account on Oracle SQL Developer to access information from another User's tables, here is the table info.

User: Inventory

Table: ORDER_LINE_ITEMS
columns: ORDER_ID,ITEM_ID,QUANTITY,ADJUSTMENT_TYPE,RELEASED _TO,ENTRY_DATE,ENTERED_BY

Table:ITEMS
Columns: ID,NAME,DESCRIPTION,IMAGE_URL,QTY,MIN_QTY,CATEGORY ,MAKE,ACTIVE_YN,NOTES


I need to write a query that will display the name of the items from inventory that have not been checked out of our system in over a year. This is what I am using so far.

SElECT name
from inventory.items
where exists(
select unique item_id
FROM inventory.order_line_items
where entry_date<='06-MAY-2010'
)
order by id ASC

But I am not getting what I need I am getting a list of items that are older but I need to eliminate the ones that have been seen since may,06 2010. any help?