BUG: Remote View Has Only Two Join Types

View products that this article applies to.

This article was previously published under Q157525

Symptoms

The Remote View designer has only two types of Join conditions, Left Outer and None.

Cause

Visual FoxPro delegates the SQL query to the ODBC driver in order to be compatible across multiple back ends. Visual FoxPro uses the ODBC outer join extension, which supports only left outer join.

↑ Back to the top

Resolution

The following code sample creates a remote view using a inner join:

Note The user must have appropriate permissions to perform these operations on the database.

      *Start Code Example
      close all
      create data Test1
      MyConnstr="driver=sql server; ";
       + server=MyServernt;uid=UserName;pwd=StrongPassword;database=pubs"
      create connection mycon connstr (MyConnstr)
      create sql view Test1 remote connection mycon Share as select * from;
        titles inner join titleauthor on ;
        titles.title_id=titleauthor.title_id
      *End Code Example

↑ Back to the top

Status

Microsoft has confirmed that this is a problem in the Microsoft products that are listed in the "Applies to" section of this article.

↑ Back to the top

More information

Steps to Reproduce Behavior

Using the 32-Bit ODBC Driver Manager, create a DataSource for a database on a Remote Server like the "pubs" database on Microsoft SQL Server.
Open a database and create a remote view using the DataSource specified above.
Add a table to the Remote View.
Add another related table to the view. When the Join Condition dialog box appears, click Cancel.
Click the Join tab of the Remote View designer and then click the Type drop-down list box.

Note that Only two Join Conditions are available: "Left Outer Join" and "<None>."

↑ Back to the top