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

Open KunjalNarola opened this issue 6 years ago • 4 comments

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?

Mar 27 '19 07:03 KunjalNarola

Also is there any way to use multiple Primary Keys?

Apr 15 '19 07:04 KunjalNarola

Did you figured out?

Sep 17 '19 15:09 daybson

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 {

Oct 21 '19 08:10 dinhdangkhoa

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

Oct 26 '19 13:10 tpnet