search

robertohuertasm / SQLite4Unity3d

SQLite made easy for Unity3d
MIT License
1.27k stars 265 forks source link

Is there any way to use JOIN in query and fetch data from multiple table? #97

Open KunjalNarola opened 5 years ago

KunjalNarola commented 5 years ago

I want to JOIN 3 table and fetch specific values from it. Can anyone provide me the Demo Query using JOIN because currently, I'm using the Query method for JOIN. Also is there a way to assign Foreign Key constrain?

KunjalNarola commented 5 years ago

Also is there any way to use multiple Primary Keys?

daybson commented 4 years ago

Did you figured out?

dinhdangkhoa commented 4 years ago

I saw this code in SQLite.cs, does it mean that the library doesn't support JOIN for the moment ? 

private SQLiteCommand GenerateCommand (string selectionList)
        {
            if (_joinInner != null && _joinOuter != null) {
                throw new NotSupportedException ("Joins are not supported.");
            }
            else {
tpnet commented 4 years ago

@KunjalNarola is there any way to use multiple Primary Keys?