From 1a7687fd000c83272b6358ba92a47967bc90d6e5 Mon Sep 17 00:00:00 2001 From: Eric Bollengier Date: Wed, 16 Sep 2009 22:07:03 +0200 Subject: [PATCH] Fix sql query --- bacula/src/cats/sql_cmds.c | 8 ++++---- 1 file changed, 4 insertions(+), 4 deletions(-) diff --git a/bacula/src/cats/sql_cmds.c b/bacula/src/cats/sql_cmds.c index 2556ab6c34..6ac1b4bb12 100644 --- a/bacula/src/cats/sql_cmds.c +++ b/bacula/src/cats/sql_cmds.c @@ -457,7 +457,7 @@ const char *select_recent_version_with_basejob[4] = { "FROM " "(SELECT FileId, JobId, PathId, FilenameId, FileIndex, LStat, MD5 FROM File WHERE JobId IN (%s) " "UNION ALL " - "SELECT File.FileId, BaseFiles.JobId, PathId, FilenameId, File.FileIndex, LStat, MD5 " + "SELECT File.FileId, File.JobId, PathId, FilenameId, File.FileIndex, LStat, MD5 " "FROM BaseFiles JOIN File USING (FileId) " "WHERE BaseFiles.JobId IN (%s) " ") AS T JOIN Job USING (JobId) " @@ -469,7 +469,7 @@ const char *select_recent_version_with_basejob[4] = { "FROM " "(SELECT FileId, JobId, PathId, FilenameId, FileIndex, LStat, MD5 FROM File WHERE JobId IN (%s) " "UNION ALL " - "SELECT File.FileId, BaseFiles.JobId, PathId, FilenameId, File.FileIndex, LStat, MD5 " + "SELECT File.FileId, File.JobId, PathId, FilenameId, File.FileIndex, LStat, MD5 " "FROM BaseFiles JOIN File USING (FileId) " "WHERE BaseFiles.JobId IN (%s) " ") AS T JOIN Job USING (JobId) " @@ -480,7 +480,7 @@ const char *select_recent_version_with_basejob[4] = { "FROM " "(SELECT FileId, JobId, PathId, FilenameId, FileIndex, LStat, MD5 FROM File WHERE JobId IN (%s) " "UNION ALL " - "SELECT File.FileId, BaseFiles.JobId, PathId, FilenameId, File.FileIndex, LStat, MD5 " + "SELECT File.FileId, File.JobId, PathId, FilenameId, File.FileIndex, LStat, MD5 " "FROM BaseFiles JOIN File USING (FileId) " "WHERE BaseFiles.JobId IN (%s) " ") AS T JOIN Job USING (JobId) " @@ -491,7 +491,7 @@ const char *select_recent_version_with_basejob[4] = { "FROM " "(SELECT FileId, JobId, PathId, FilenameId, FileIndex, LStat, MD5 FROM File WHERE JobId IN (%s) " "UNION ALL " - "SELECT File.FileId, BaseFiles.JobId, PathId, FilenameId, File.FileIndex, LStat, MD5 " + "SELECT File.FileId, File.JobId, PathId, FilenameId, File.FileIndex, LStat, MD5 " "FROM BaseFiles JOIN File USING (FileId) " "WHERE BaseFiles.JobId IN (%s) " ") AS T JOIN Job USING (JobId) " -- 2.39.5