All Notes on BCA

Select c.name, c.address, c.city from 
customer_t6 c JOIN order_t6 o ON c.cust_no = o.client_no 
where o.order_no = 'o00001';

NAME     ADDRESS    CITY
-------- ---------- ---------------
pratik   kankroli   rajsamand