Hi all,
I am joining two tables like tbl1, tbl2 having 10 fields and 4 fields each having Inlinktbl1.Field1 and Inlinktbl2.Field2 as key columns
-----------------ODBC
--------------------|
--------------------|
ODBC------->TRF------->ODBC
I am taking 9 fields from tbl1 and 3 fields from tbl2
and using the key fields in constraint as inner join.
the job is aborted showing the error like..
DSD.BCIOpenRef call to SQLNumResultCols failed.SQL statement has incorrect number of result columns.
I could not get anything from this...
Any suggestions are welcomed
Thanks in advance
Incorrect No. of columns error while using Join
Moderators: chulett, rschirm, roy