mapbox/tilemill — Issue #825: LEFT OUTER JOIN for sqlite attach db
Author: misterboo
Created: 2011-10-21 13:58:24+00:00
State: open

The attach db is a great feature. At the moment i guess there is only INNER JOIN.

It would be nice if LEFT OUTER JOIN would also work.

Look at your example:

http://developmentseed.org/blog/2011/aug/30/tilemill-05-adds-sqlite-datasource-support/

With INNER JOIN the Coutries are be missing which have no entry in gdp.sqlite

![join](temp.misterboo.de/tilemill/join.png)

With LEFT OUTER JOIN all countries would be included.