>Does anybody know why the VFP 5 view designer does NOT let me create an INNER JOIN in a remote view to SQL Server 6.5?
>
>The combo box on the 'Joins' tab only display LEFT OUTER JOIN.
The default syntax of SELECT * FROM x,y where x.key=y.key is an Inner Join.
Wayne
Wayne Myers, MCSD
Senior Consultant
Forte' Incorporated
"The only things you can take to heaven are those which you give away" Author Unknown