[EMAIL PROTECTED] wrote:
As you can see, the same color (the last one, emissive) will be the
result for ALL colors. It seems as if your SQL-interpreter cannot
handle
multiple definitions of the same table (aliased with AS) in the
FROM-clause?
Everything works correctly for me with sqlite3 command line utility, and
with SQLite Explorer. The problem must be in the visual tool you are
using (which looks quite half-baked, what with all the %s placeholders
in the UI).
Igor Tandetnik
-----------------------------------------------------------------------------
To unsubscribe, send email to [EMAIL PROTECTED]
-----------------------------------------------------------------------------