Re: [Bacula-users] Bacula enhancements for 'list jobs'

SourceForge Headquarters 225 Broadway Suite 1600 San Diego, CA 92101 +1 (858) 454-5900

> On Sat, Oct 30, 2004 at 12:26:59AM +0200, Arno Lehmann wrote:
> > 29-Oct-2004 23:14 goblin-dir: *Console*.2004-10-29_22.42.47 Fatal error: 
> > sql_list.c:276 sql_list.c:276 query SELECT 
> > JobId,Name,StartTime,Type,Level,JobFiles,JobBytes,JobStatusLong FROM Job 
> > JOIN Status ON Job.JobStatus=Status.JobStatus ORDER BY StartTime failed:
> > You have an error in your SQL syntax near 'ON 
> > Job.JobStatus=Status.JobStatus ORDER BY StartTime' at line 1
> > 29-Oct-2004 23:14 goblin-dir: sql_list.c:276 SELECT 
> > JobId,Name,StartTime,Type,Level,JobFiles,JobBytes,JobStatusLong FROM Job 
> > JOIN Status ON Job.JobStatus=Status.JobStatus ORDER BY StartTime

On Fri, Oct 29, 2004 at 07:17:09PM -0400, Phil Stracchino wrote:
> What version of MySQL are you running?  This looks as though you're
> running an older MySQL that doesn't support that JOIN syntax.

That version is never supported (by ANSI anyway).  Just add "LEFT" before
JOIN...

SELECT JobId,Name,StartTime,Type,Level,JobFiles,JobBytes,JobStatusLong 
	FROM Job 
	LEFT JOIN Status ON Job.JobStatus = Status.JobStatus ORDER BY StartTime

For MySQL-only you could also use 
SELECT JobId,Name,StartTime,Type,Level,JobFiles,JobBytes,JobStatusLong 
	FROM Job 
	LEFT JOIN Status USING (JobStatus) ORDER BY StartTime

but the ANSI-standard way is much better.

-- 
Joe Rhett
Senior Geek
Meer.net