I try co create a SQL query with two inner joins and an if case. I create an example to explain what I mean:

In words, the query should do: Search in the first table for ID 125, so I get Typ CCC and Case yyy If case is yyy then search in the second table for CCC in column Typ1, here I get the ID 777 and then search in the third table for 777 in column ID2 to get the result 3. If case is not yyy then just show me the results of the first table. The result should be:

I hope you can understand what I try to explain :)

CodePudding user response：

You want to select data from the first table and only show data from the other tables where appropriate. So, outer join the other tables.

select t1.id, t1.typ, t3.result
from t1
left outer join t2 on t2.typ1 = t1.typ and t1.case = 'yyy'
left outer join t3 on t3.id2 = t2.id1
order by t1.id;

CodePudding user response：

You can do it without placing an if condition. Just include the condition in the JOIN part of your query

SELECT t1.ID, t1.Typ, t3.Result 
FROM table1 t1 
INNER JOIN table2 t2 ON (t1.Typ = t2.Typ1 AND t1.Case = "yyy") 
INNER JOIN table3 t3 ON (t2.ID1 = t3.ID2 AND t2.ID1 = 777)