[Solved] Sqlite select value as id to other table

by


You need to fix your table A so it is in First Normal Form:

Name  Value
a     13889483-d92a-483e-9e16-471cb22b82a3
a     a7ced9c5-e7bc-4214-be77-a26d8f86844b

Then you can connect the tables using a SQL join:

SELECT B.* FROM A
JOIN B ON B.Name = A.Value
WHERE A.Name="a"

solved Sqlite select value as id to other table