I'm having difficulty with the JOIN clause of the SQL-SELECT command. It works well enough with simple inner joins of two or three tables but queries that contain many tables crash. I'm finding that complex views simply can't be created.

My boss tells me that he has experienced this same problem since the release of VFP 5 and advises me to use the WHERE clause to create my joins, like in the "old days". This works, of course, but I'd like to be able to create views with outer joins and I'm sure there is a solution.

Has anyone else experienced this same difficulty? Is there a bug-fix or am I just doing something wrong? In order to keep this message as readable as possible, I haven't included examples of views that don't work but I can, if necessary.