Join Expressions Not Working

[harlankoehn]

Does this .NET VFP Client support Join Expressions? I tried JOIN, INNER JOIN, LEFT JOIN, etc., and couldn't get any of them to work. I get a fairly generic error message about the provider not supporting or recognizing something in my SQL.

My tables are not free tables, they are part of a database, but they do not have primary keys. It's not a database I can modify. I'm integrating with another companies software.

I can do pseudo joins using:

SELECT field1, field2
FROM table1, table2
WHERE table1.ID = table2.ForeignKey

But I'd rather be able to use joins if I can.

[tombrothers]

VfpClient works with join statements. I used the following code to verify using the northwind.dbc.

 using (var connection = new VfpConnection(@"e:\NorthwindData\Northwind.dbc")) {
    using (var command = connection.CreateCommand()) {
        command.CommandText = "select c.CustomerId, o.OrderId from customers, orders o where c.CustomerId = o.CustomerId";

        var adapter = new VfpDataAdapter(command);
        var table = new DataTable();

        adapter.Fill(table);
    }
}

Is it possible that your query includes a VFP function call that isn't supported by the OLE DB Provider?

[harlankoehn]

That works but I'm still not sure how I'd do a left Join if I wanted to. Appears that probably wouldn't be possible.

[tombrothers]

Example 7 shows the syntax.