• 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
codeigniter join

#1
Code:
SELECT `payment`.* FROM `payment`

LEFT JOIN `people` as `P` ON `P`.`id` = `payment`.`customer_id` and ( `payment`.`customer_type` = 'P' or `payment`.`customer_type` = 'CP' or `payment`.`customer_type` = 'LP' or `payment`.`customer_type` = 'BP' or `payment`.`customer_type` = 'TS' )

LEFT JOIN `branch` AS `B` ON `B`.`id` = `payment`.`branch_id` WHERE `payment`.`status` = 'active' AND `payment`.`type` = 'Income' AND `payment`.`mode` = 'Payin' GROUP BY `payment`.`customer_id`


here i need to convert codeigniter query with join condition pls tell me how to do it ,bcz this query has multi and / or condition in join

pls someone help me
Reply


Messages In This Thread
codeigniter join - by durairaj - 02-23-2021, 12:38 AM
RE: codeigniter join - by durairaj - 02-23-2021, 04:14 AM

Digg   Delicious   Reddit   Facebook   Twitter   StumbleUpon  


  Theme © 2014 iAndrew  
Powered By MyBB, © 2002-2021 MyBB Group.