Browse by Tags

Problem reading join tables

Hi everyone, I have two tables that I want to join. This is my C# code: private static void readTable() { SQLiteConnection cn = null ; try { cn = new SQLiteConnection (Connessione); cn.Open(); SQLiteCommand cmd = cn.CreateCommand(); cmd.CommandText = "SELECT * FROM OB_Stops INNER JOIN OB_StopDetails...

Posted to How To (Forum) by jam1982 on 08-21-2009
Re: Fastest way to mix 3 tables into a fourth?

Size: daily.t2 rows: 459545 daily.t3 rows: 306127 Command: INSERT INTO main.t1(time, ID, b, c, d, e, f, g, h) SELECT t.time, t.ID, t.b, t.c, t.d, t.e, s.f, s.g, s.h FROM daily.t2 t LEFT OUTER JOIN daily.t3 s ON t.ID = s.ID AND t.time=s.time GROUP BY t.time, t.ID Using: ==============================...

Posted to How To (Forum) by Beltxo on 07-10-2008
Re: Fastest way to mix 3 tables into a fourth?

Now that I'm back at the office, I have implemented and tested your code and I got some strange results. I needed to forget the third table due to bad performance: INSERT INTO main.t1(time, ID, b, c, d, e, f, g, h) SELECT t.time, t.ID, t.b, t.c, t.d, t.e, s.f, s.g, s.h FROM daily.t2 t LEFT OUTER...

Posted to How To (Forum) by Beltxo on 07-08-2008

Page 1 of 1 (3 items)

System.Data.SQLite