Tuesday, April 24, 2012

SQLITE Sql query to get the value while comparing value

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