具有2个条件的SELECT查询和第二个条件来自第一个条件的结果

Question

so what I want to achieve is that there will be two select conditions which getting data from the same table but different conditions. where the condition of the second select is from the result of the first table but will still have joined results to display in the view.

SELECT * FROM tablea WHERE title_id = 1;
SELECT * FROM tablea WHERE song_id = tablea result;

Answer 1

You can do something like this:

SELECT * 
FROM table_name 
WHERE id IN (SELECT id 
             FROM table_name 
             WHERE ...) 
      AND ...

P.S.: Sharing your database schema would help us help you.