Enquiry from two different tables

[slimdave]

You need to write a SQL query that joins the two tables. For example ...

select customer_type, ProductID, Order_Date
from table_a a, table_b b
where a.emailadd = b.emailadd
and order_date >= to_date('01-oct-2005')
and order_date < to_date('01-nov-2005')
order by customer_type