Unexpected Results in HeidiSQL

Hello

I'm facing an issue with a complex JOIN query in HeidiSQL. I'm here trying to join multiple tables to retrieve specific data, but I'm not getting the expected results. Check below:

SELECT * FROM table1 INNER JOIN table2 ON table1.id = table2.table1_id INNER JOIN table3 ON table2.id = table3.table2_id WHERE condition = 'value';

This query doesn't seem to return the correct results, and I doubt there might be an issue with my JOIN conditions or the way I'm structuring the query. Can anyone provide some suggestions on how to troubleshoot this problem effectively?

Any help would be greatly appreciated!

Thank you.