sql - How To Select All Rows In A Table By Querying Data In Another Table

Question

I have 3 SQLite tables that must be queried to obtain the final data.

I must select everything in ItemAppearance where DisplayType == 4
Then take the corresponding number from the ID field and
Select all rows in ItemModifiedAppearance where ItemAppearanceID == Previous Number
Then take the corresponding number ItemID field and
Select all rows in ItemSearchName where ID == Previous Number
Finally, I can retrieve a large list of all the Display_lang values that I need.

Graphically:

What's the best / fastest / most efficient way to get this list of strings?

question from:https://stackoverflow.com/questions/65623546/how-to-select-all-rows-in-a-table-by-querying-data-in-another-table

Answer 1

Your question is a bit confusing, but I'm guessing here join is your friend:

SELECT *
FROM ItemAppearance ia LEFT JOIN 
     ItemModifiedAppearance im
     ON ia.ID==im.ItemAppearanceID JOIN
     ItemSearchName isn
     ON ia.ID==isn.ID
WHERE ia.DisplayType = 4;

So that just gets all 3 databases, where all the id's match, but only the ones that are in ItemAppearance that are of DataType 4.

Hopefully that helps, or makes sense, or was even in the ballpark of your question. Let me know.