- DB created with sample.
- Table1
rowid       myID        myName                  
----------  ----------  ------------------------
1           100         First  value with ID 100
2           10          Second value with ID 10 
3           1           Third  value with ID 1  
- Table2
myID        myID        myName                  
----------  ----------  ------------------------
1           1           Third  value with ID 1  
10          10          Second value with ID 10 
100         100         First  value with ID 100
- Select sample (rowid=100 from table2)
First  value with ID 100