[v4rb v1] sql help with LEFT OUTER JOIN

[Ivan Smahin]

Robert Nichols wrote:
> I am a SQL novice, but have been improving steadily as I work with  
> Valentina. I have a LEFT OUTER JOIN working properly using v2, but in  
> an earlier v1 project, I keep getting 602 errors from the following  
> select string:
> 
> s = "SELECT projects.recid,users.shortname FROM projects LEFT OUTER  
> JOIN users ON projects.user=users.recid"

You could try another syntax:
SELECT
	projects.recid,users.shortname
FROM
	projects, users
WHERE
	projects.user *= users.recid

-- 
Best regards,
Ivan Smahin