Error with complex Oracle query |
04-15-2018, 11:55 PM
(This post was last modified: 04-16-2018, 02:21 AM by ciadmin. Edit Reason: SEO link redacted )
$this->db->from("passport_users, (select pi.username,
pi.passport_number, max(pid.passport_status_date) pmax_status_date from passport_information pi, passport_information_detail pid where pi.username = pid.username group by pi.username, pi.passport_number) p_max_status, passport_information ppi, passport_information_detail ppid, passport_status ps"); |
Welcome Guest, Not a member yet? Register Sign In |