Combine 2 tables to create Tree in ExtJS 7

Question

MySQL has 2 tables with the same rows.

For an edit I need one TreeList without true leafs and edit the true leafs separately in a Grid and for the Employees i need one TreeList with the true leafs.

It look like this:

How can I create MySQL query to make sure I can use two separate tables as a one?

The simple way to show the Tree is this query:

 $sql =  'SELECT * FROM '.TP.'lv_tree AS lvtree '.
         'WHERE lvtree.parentId = ?';

    $result = $db->connect()->prepare($sql);
    $result->bindParam(1, $_REQUEST['node']);   

    $result->execute();

I have already tried JOIN, LEFT JOIN, etc., but to no avail.

Try SQL UNION: ` 'SELECT * FROM '.TP.'lv_tree AS lvtree '. 'WHERE lvtree.parentId = ? UNION SELECT * FROM '.TP.'lv_tree AS lvtree2 ' 'WHERE lvtree.parentId = ?'; — Arthur
– Arthur, Commented Aug 20 at 12:46
For the edit: if you are going to edit leaf by leaf, you can do it in the tree without any need to bind it to a grid. — Arthur
– Arthur, Commented Aug 20 at 12:48

Charles Candy · Accepted Answer · 2025-08-29 17:49:10Z

0

my example assume both in one table . if wrong just modify

select
*
from
(
    select  
        * 
    from 
        lvtree 
    where 
        parent_id = 0 and leaf = false
) as A
left outer join (
    select  
        * 
    from 
        lvtree 
    where 
        parent_id <> 0 and leaf = false
) as B
    ON B.parent_id = A.id
left outer join (
    select  
        * 
    from 
        lvtree 
    where 
        parent_id <> 0 and leaf = true
) as C
    ON C.parent_id = B.id

answered Aug 29 at 17:49

Charles Candy

597 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Combine 2 tables to create Tree in ExtJS 7

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related