From c5b18651304e6b80a3ac3c440b99fcbd27153b93 Mon Sep 17 00:00:00 2001
From: David Sommerseth <dazo@users.sourceforge.net>
Date: Sat, 26 Sep 2009 00:10:48 +0200
Subject: Only add table alias in SQL 'WHERE' sections

---
 database/sqlite/sqlite.c | 2 +-
 1 file changed, 1 insertion(+), 1 deletion(-)

(limited to 'database/sqlite')

diff --git a/database/sqlite/sqlite.c b/database/sqlite/sqlite.c
index 263ef97..afe4077 100644
--- a/database/sqlite/sqlite.c
+++ b/database/sqlite/sqlite.c
@@ -388,7 +388,7 @@ char *_build_sqlpart(int btyp, eDBfieldMap *map) {
 
                         // Put the pieces together and append it to the final result
                         val = _build_value_string(ptr);
-                        if( ptr->table_alias != NULL ) {
+                        if( (btyp == btWHERE) && (ptr->table_alias != NULL) ) {
                                 append_str(buf, ptr->table_alias, 8192);
                                 append_str(buf, ".", 8192);
                         }
-- 
cgit