Eric DAVID wrote: > > Yes, it is this one. With the new script I gave in my last mail it has > changed to > > SELECT * FROM Pylones P > JOIN Lignes L ON L.lig_id = P.lig_id > JOIN idx_Pylones_pyl_geom I ON P.pyl_id = I.pkid WHERE L.lig_id = 1; >
So far, I'm unable to reproduce your results here. Could you please provide the list of all SQL statements used to get the database into the state where the issue is seen, including any INSERT statements used to populate it with the test data. -- Joe Mistachkin _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
