There are three table.
Table X
| Field 1 | Field 2
Table Y
| Field 2 | Field 3
Table Z
| Field 3 | Field 4
The idea is to get the row from table Z but need to go from table X comparing a value selected value for field 1.
From Table X field 1, will get the value for field 2. On Table Y the value from field 2 will get the value for field 3.
On Table Z field 3 will get the final value from Field 4.
Any idea on how to do it in sqlite?
No comments:
Post a Comment