Thanks Andy, I know what you are saying (but sure it was an "Inner" join) - I authored in Studio and verified in Maestro but will try again especially if someone can run through the steps below independantly. Meastro also has an "Associative" join - do you know what that is?
Andy Morsell wrote: > > It sounds like you have an outer join specified for your join rather than > an > inner join. In Studio 2009, you have the option of selecting an outer or > inner join. If you're not using Studio 2009, I'm not sure what options > you > have, but you can edit the XML and upload the datasource via the mapagent. > The XML element <RelateType> should be set to Inner. > > Andy Morsell, P.E. > Spatial Integrators, Inc. > www.SpatialGIS.com > > > -----Original Message----- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] On Behalf Of > Crispin_at_1Spatial > Sent: Monday, August 25, 2008 5:56 AM > To: [email protected] > Subject: [mapguide-users] Feature Joins - How? > > > Hi, > > Trying to understand feature joins so I tried some tests and failed > miserably... can anyone expand on the logic below: > > 1) I created a new featuresource and layer (SDF data), turned the FeatId > on > as the tooltip and previewed the data, noted down a FeatId that I could > readily identify (e.g. 123) > > 2) I created an Access DB with a new table and a column (Numeric, Long) > called ID_NumLong and made it a primary key, then added one value to the > table as noted above (e.g. 123) > > 3) I added an ODBC system DSN to the MDB and in MapGuide a new ODBC > feature > source connection. > > 4) I edited my original layer, linked the new ODBC featuresource as a > join > and selected FeatId->ID_NumLong as an Inner join > > 5) Previewed the layer expecting to see only the linked feature displayed > ... but the complete dataset displayed as before. Not happy. > > -- > View this message in context: > http://n2.nabble.com/Feature-Joins---How--tp781352p781352.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 > > > _______________________________________________ > mapguide-users mailing list > [email protected] > http://lists.osgeo.org/mailman/listinfo/mapguide-users > > -- View this message in context: http://n2.nabble.com/Feature-Joins---How--tp781352p782211.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
