Perform a second screening from the result set

Kotlin
IOS
VB.Net
SQL
Node.js
Swift
Ruby
Go
Oracle
Git
Laravel
Mongodb
Asp.Net
More...

as shown in the figure, this association query is different in that it is associated with the same table

indicates that table_test

requirement: first query the result set of the field whose reply_type is 0, and then use the reply_id of the result set as the primary key to query the associated reply_parent

Nosql oracle sql mysql

Mar.07,2021

select t1.* from table_test T1 left join table_test T2 on t1.reply_id = t2.parent where t1.reply_type = 0;
see if it is what you want

you can first query the data with zero type in the table_test table to form an intermediate table, and then query the middle

Previous: 403 Forbidden nginx/1.4.4 error occurred when accessing php file, how to solve it?

Next: Use the download attribute to download continuously, but only one copy can be downloaded in the high version of chrome.

False
Django, Why does the system automatically generate an empty session? every time the request is made?
Use python to convert dict1 to dict2, in the example. I tried for a long time but couldn't find a solution.
How to self-start the php-fpm service when building a LNMP environment with docker?
Can an array in react state be bound to a dom state using an element in the array?
Wechat browser version 6.6.5 cannot prevent the springback of pull-up and drop-down to the top under ios system.
In express+hbs, how do you define the routed data as a variable on the page?
How to use symbol reference of Iconfont in dva
How to elegantly add data to JSON objects?
Using node to build video streaming server
The proportional width of the echarts graph is inconsistent.
React uses axios to call the background data. After success, how to jump to the page based on the returned value?
I don't understand what a linux command means. Please explain it.
Vue introduces multiple components in vue-router by nesting named views, and does not refresh the same reference in other pages.
Running nodejs reports fewer errors ")"

How to configure the loading attribute of button in iview table
For loops json data to html for repeated output
RequireJS-use r.js to achieve module, project compression and merge, so far I only achieve js compression, can I compress html files?
Using nodejs to update the table of mysql, the parameters after SET are not fixed, how to achieve? Add SET after?? How do you understand it?
Is there any difference between the two for loops in php?