Manage Child Accounts

08-25-2026 21:56:20 SQL Statement: SELECT t.id, t.childId, t.parentId, t.childAccountNum, t.childStatus, t.childDeactive, t.childFirstName, t.childLastName, t.childCompany, t.parentAccountNum, t.parentWholesale, t.parentFirstName, t.parentLastName, t.parentCompany FROM (SELECT pair.id AS id, pair.child_id AS childId, pair.parent_id AS parentId, c.account_number AS childAccountNum, c.status AS childStatus, c.inactivation AS childDeactive, c.first_name AS childFirstName, c.last_name AS childLastName, c.company_name AS childCompany, p.account_number AS parentAccountNum, p.wholesale AS parentWholesale, p.first_name AS parentFirstName, p.last_name AS parentLastName, p.company_name AS parentCompany FROM customer_parent_child pair LEFT JOIN customer c ON pair.child_id = c.id LEFT JOIN customer p ON pair.parent_id = p.id) AS t WHERE t.parentId = '24' ORDER BY t.childId