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

[KunjalNarola]

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]

Also is there any way to use multiple Primary Keys?

[daybson]

Did you figured out?

[dinhdangkhoa]

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]

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