SQL Join

[dkitoko]

Im tryn' to make a join in MapGuide studio 2009 between a shapefile and a table stored in SQL Server 2008.But when I try to join,the result only displays 3 entries.There are 4 entries to be displayed.I tried this step in AutoCAD MAP 3D 2009 using SQL and Acess and works.But when I tried to do same in Studio,using both Acess and SQL,only displays 3 entries.
I used the new SQL provider for Spatial 2008 and still doesn't work.
There's something wrong?

[Jmurphy]

Dilson,
If you are on subcription you may want to log a support request there. Another place to look for an answer is on the OSGEO site for Map Guide OS, the folks using the OS version are more up to speed on working out issues like this than those here in AUGI.