All Notes on BCA

select c.name, o.order_date from 
customer_t6 c JOIN order_t6 o on c.cust_no = o.client_no 
where o.order_date < '12-jan-16';

NAME                 ORDER_DAT
-------------------- ---------
pratik               12-JAN-96
aman                 25-JAN-96
dilkhush             18-FEB-96
Ajay                 03-APR-96
Ajay                 03-APR-96