SQLite database select query from multiple tables for windows phone

Question

Trying to develop a Windows phone 8.0 Store App.I need to retrieve records from a sqlite database which are having two tables so far i did not found any tutorial for it .here is what i am doing for get data from one table

var retrievedTasks = dbConn.Query<MMain>("SELECT MMain.ID,           MMain.Name, health.age
FROM MMain INNER JOIN health ON MMain.key = health.key
where MMain.ID = 1" ).FirstOrDefault();

but i want to achieve this to get data from two tables

       foreach (var rr in retrievedTasks)
        { 

         //how to fetch data from health class table 
        }

so how to do this and than how to fetch Data from it

he

SD7 · Accepted Answer · 2015-08-12 09:55:53Z

1

Your query looks wrong (one extra comma and you should use INNER join with the relevant ON clause)

SELECT MMain.ID, MMain.Name, health.age
FROM MMain INNER JOIN health ON MMain.key = health.key
where MMain.ID = 1

Apart that, I don't see the pb.

edited Aug 12, 2015 at 9:55

SD7

5148 silver badges25 bronze badges

answered Aug 12, 2015 at 8:19

tafia

1,5929 silver badges18 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

SQLite database select query from multiple tables for windows phone

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related