Hi I'm working with Oracle and needed help writing some statements.

I have a table called ITEM with row - item_name
a table called SEND with row - send_date
a table called DESTOY with row destoy_date


What SQL statement would I write if I wanted...

1. List all values for item_name, send_date, and destoy_date.

2. List all common values for send_date and destoy_date.

3. List all values for destoy_date that are not also values for send_date.


THANK YOU FOR ANY HELP

can you please post the whole schema of your table on which join needs to be performed