⚠ In case you've missed it, we have migrated to our new website, with a brand new forum. For more details about the migration you can read our blog post for website migration. This is an archived forum. ⚠

  •     

profile picture

Joins Two or more tables



kishor10d
  • profile picture
  • Member

Posted 24 December 2014 - 08:11 AM

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


Paul Savostin
  • profile picture
  • Member

Posted 07 January 2015 - 23:23 PM

Hi! Why simple ->set_relation not working for you?