add join failure and attribute table column limit

Discussion created by helenak on Jul 10, 2013
Latest reply on Jul 11, 2013 by Hornbydd
System: ArcGIS 9.3 and Vista


I am using the function add join to combine three shape files into one shape file. (by python script)
Each of them has about 650 columns in the attribute table.

However, the add join always failed.
The error message is
Could not load data from the data source
If you can correct the problem, click the refresh button to refresh data.
Possible problems can include bad network connection, invalid field, etc.
An invalid SDE statement was used.
(I am sure nothing to do with invalid field,*
because all the shape files were produced by the add join method. )

I am wondering if the cause was the over-limit column number.
If so, please kindly advise alternative methods to complete the combination.
Thank you.