Thanks for suggestion. I afraid i cannot change id data type to integer since it contains both of integer and char such as 'FLAG 010'..i just wondering if this is related to the space between 'FLAG' and '010'??
Try linking the tables with integer columns, that is usually the only stable solution. Regards, Kenneth Skovhede, GEOGRAF A/S anakando skrev: > Yes..my MG version is 2.0.1..Here is my situation. I have database that > contain 2 tables (as example). Both of tables are linked to SDF file -- View this message in context: http://www.nabble.com/MS-SQL-and-SDF-Join-Problem-tp19448719p19450975.html Sent from the MapGuide Users mailing list archive at Nabble.com. _______________________________________________ mapguide-users mailing list [email protected] http://lists.osgeo.org/mailman/listinfo/mapguide-users
