MySQL join problems

[Charles Theobald]

Hello,
I'm having difficulties performing a join between a localhost shapefile 
and a remote Mysql table.  The following command works, performs the 
join and display the results. 
/fgs/bin/ogrinfo  /fgs/www/htdocs/stateplane/97service.shp -sql "SELECT 
* FROM 97service LEFT JOIN 
'MYSQL:dreporting,host=mimir,user=****,password=*******,tables=sysstatus'.sysstatus 
ON 97service.ID = sysstatus.permit"

However, I can't get the syntax right in my .map (or .ovf) file. 
Any suggestions?
Thanks in advance.