Here is my mySQL query which I used to get the details from three tables.
SELECT `pg`.`id`, ref, business_name, `usr`.`full_name`, date, `pmt`.`amount`, `pg`.`status` FROM kv_ad_orders AS `pg` LEFT JOIN kv_users AS `usr` ON `pg`.`sales_rep_id` = `usr`.`ID` RIGHT JOIN kv_payments AS `pmt` ON `pg`.`ref` = `pmt`. `transId`
here it shows only the
kv_payments table entries only. Not the whole results. I want to display all the selected columns.
If I make it as left join table, than its showing other results except the amount.