All Questions
2 questions
0
votes
1
answer
2k
views
Get all childs by parent id using JOIN
I have a table representing the family tree. It has fields ID, NAME, LEVEL, PARENT_ID.
And the column PARENT_ID is the foreign key and refers to column ID of this table. How can I get a list of ...
- 211
2
votes
2
answers
11k
views
MySQL Query Join to select unmatched rows from two tables
I have two tables as below.
user_id | username | first_name | role_type
-----------------------------------------------------------
1 | testuser1 | testu1 | ...
- 12.3k