Select Query
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';

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



Leave a Reply

Subscribe to Posts | Subscribe to Comments

All Notes on BCA

All Notes  on BCA
BCA all subjects notes

Total Pageviews

Translate

Powered by Blogger.

Copyright © All Notes on BCA