Hello,
I have 2 tables
1) Customer
i) customer_id
ii) customer_name
iii) date_of_birth
2) Customer_Request
i) request_id
ii) customer_id
iii) approved
I want to show output like this...
customer_id | customer_name | approved
and I want to show records for those customers who come up with request
means show records where Customer_Request.customer_id = Customer.customer_id
Is it possible?
Thanks in advance