On 30 Jan 2012, at 11:16am, Pawl wrote: > | 05.01.2011 | 7.7 | 01.05.2011| 0.7 | 12.1 | > +------------+-------+-----------+----------+-----------+ > ... > > I tried to use cmd JOIN in this content, but didn't work it. > > SELECT JX.*,JX_lim.* FROM JX JOIN JX_lim ON JX_lim.edittime <= JX.starttime
Your dates are stored in with the components in an unuseful order. SQLite doesn't have a datetime format. Values like the ones above will probably be stored as strings. If you want your SELECT to work (and I don't think there's anything wrong with it) then your dates should be stored in a format like "20110105" (string) "2011/01/05" (string) "2011-01-05" (string) unix epoch (floating point) juliandate (integer) You have to store all dates in the same format, so pick one of the above (or something similar) and be consistent. Simon. _______________________________________________ sqlite-users mailing list [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
