I made a connection to 2 textfiles(called: .PNT, .PN2) successfully in c#, now I am trying to join between these 2 connections, I can make this through the GUI and it succeeded, but when trying the below code it gives me the error message " Error from SQL parser or SQL syntax error".

I made an equijoin object to join between the 2 text files, and the 2 fields I want to join are both named "Point",

I got an error as follows:

The join field names property has not been set, or it is not set correctly. All non-union joins require at least one field to join on. The field names have to go in a 2-dimensional array, each dim corresponding to the Left and Right Recordsets.