SELECT t_dados.id
FROM Points1 LEFT JOIN t_dados ON Points1.object_id = t_dados.id
ORDER BY t_dados.id, Points1.geom_id;
--- "Bruno S. Oliveira" <[EMAIL PROTECTED]> wrote:
> I'm having problems with the following query (and, in general, in
> queries using left joins):
>
> [EMAIL PROTECTED]:~$ sqlite3 parana
> SQLite version 3.4.1
> Enter ".help" for instructions
> sqlite> SELECT t_dados.id FROM (Points1 LEFT JOIN t_dados ON
> Points1.object_id = t_dados.id) WHERE 1 = 1 AND 1 = 1 ORDER BY
> t_dados.id, Points1.geom_id;
> SQL error: no such column: t_dados.id
____________________________________________________________________________________
Looking for a deal? Find great prices on flights and hotels with Yahoo!
FareChase.
http://farechase.yahoo.com/
-----------------------------------------------------------------------------
To unsubscribe, send email to [EMAIL PROTECTED]
-----------------------------------------------------------------------------
