Am 09.12.2013 um 10:06 schrieb Clemens Ladisch :
> skywind mailing lists wrote:
>> Assume I have the following tables:
>>
>> CREATE TABLE A (ID INTEGER PRIMARY KEY, Latitude, Longitude, Altitude);
>> CREATE VIRTUAL TABLE B USING RTree (ID, FromLatitude, TillLatitude,
>> FromLongitude,TillLongit
skywind mailing lists wrote:
> Assume I have the following tables:
>
> CREATE TABLE A (ID INTEGER PRIMARY KEY, Latitude, Longitude, Altitude);
> CREATE VIRTUAL TABLE B USING RTree (ID, FromLatitude, TillLatitude,
> FromLongitude,TillLongitude);
>
> According to the RTree documentation this query s
>> SELECT COUNT(*) FROM A,B
>
>Is "A,B" a way of expressing "A JOIN B" ? I've never seen it before.
Yes. It is part of the SQL language definition since before there was an SQL
language definition.
"," means "JOIN" or more pedantically "INNER JOIN". "ON" means "WHERE". The
only circumstance
On 8 Dec 2013, at 11:03pm, skywind mailing lists
wrote:
> SELECT COUNT(*) FROM A,B
Is "A,B" a way of expressing "A JOIN B" ? I've never seen it before.
Simon.
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mail
Assume I have the following tables:
CREATE TABLE A (ID INTEGER PRIMARY KEY, Latitude, Longitude, Altitude);
CREATE VIRTUAL TABLE B USING RTree (ID, FromLatitude, TillLatitude,
FromLongitude,TillLongitude);
and there is an index on A for Latitude,Longitude. B is filled using
INSERT INTO B SELECT
5 matches
Mail list logo